View Single Post
Old 11-21-2019, 04:06 PM   #73
Hanni
First Line Centre
 
Hanni's Avatar
 
Join Date: Apr 2009
Exp:
Default

Do you even need to worry about indirect?

I just did 3 months and a random bunch of names in B5:B35

Code:
=SUMIF(Jan!B5:B9, "John", Jan!D5:D9)+SUMIF(Feb!B5:B9, "John", Feb!D5:D9)+SUMIF(Mar!B5:B9, "John", Mar!D5:D9)
Instead of the name in quotations you could point it to another cell that has the name you want to add to the total

Code:
 =SUMIF(Jan!B5:B9, Summary!J1, Jan!D5:D9)

Last edited by Hanni; 11-21-2019 at 04:08 PM.
Hanni is offline   Reply With Quote
The Following User Says Thank You to Hanni For This Useful Post: