Hello
I would to sum data with 2 criteria across multiple worksheets.
So far, I have this formula which works:
Formula:
Please Login or Register to view this content.
But, I only want to sum those cells whereby the 'Account Code' is X and the 'Staff Member' is Y. So I've tried using this which results in #VALUE!:
Formula:Please Login or Register to view this content.
'ACL010:AHC010'!C$6:C$25 = Account Code
'ACL010:AHC010'!D$6:D$25 = Staff Member
Any ideas?
Thanks
Last edited by PDBartlett; 09-01-2015 at 10:53 AM.
You need use this approach ..
=SUMPRODUCT(SUMIF(INDIRECT("'"&SheetList&"'!A2:A10"),D2,INDIRECT("'"&SheetList&"'!B2:B10")))
Where "Sheetlist" is named range contain your sheet names
That's worked thanks!
But it's only using one criteria, how do I add another into it?
Managed to get it to work with multiple criteria
Formula:Please Login or Register to view this content.
Well done!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks