Hey, have been reading this thread, to try and get some clarity, but it's not heling me. Whilst I understand Sumifs, and sumproducts, the indirect part of this is throwing me just a little.
In essence, what I'm looking to do, if to find the contents of a cell on the main spreadsheet, to find it all on all the spreadsheets from November to the Initial Lease. The cell it's looking for will be in the B column, the value it should be summing across the the different sheets is in column F.
This is what I'm attempting to use:
=SUMPRODUCT(SUMIF(INDIRECT("'"&November:Initial Lease&"'!B:B"),B6,INDIRECT("'"&November:Initial Lease&"'!F:F")))
And then i get a #name error, when, as fas as I can see, the names of the sheets involved are right?
If someone could give me some help on this I'd be grateful!
Thanks in advance,
In essence, what I'm looking to do, if to find the contents of a cell on the main spreadsheet, to find it all on all the spreadsheets from November to the Initial Lease. The cell it's looking for will be in the B column, the value it should be summing across the the different sheets is in column F.
This is what I'm attempting to use:
=SUMPRODUCT(SUMIF(INDIRECT("'"&November:Initial Lease&"'!B:B"),B6,INDIRECT("'"&November:Initial Lease&"'!F:F")))
And then i get a #name error, when, as fas as I can see, the names of the sheets involved are right?
If someone could give me some help on this I'd be grateful!
Thanks in advance,