Trying to do a SUMIF from the SUMMARY TAb?????

[Jaimee001]

Greetings to all!

I have an excel workbook that has 12 tabs (1 for each month) and a summary tab.

IN each of the 12 tabs I've done 2 SUMIF formulas to get 2 different numbers and then in the SUMMARY tab just did an = to pull that value over...

Is there a way to do the actual SUMIF in the summary tab?

See the example:

[pre]http://speedy.sh/mf9ak/example-for-summary-tab.xlsx[/pre]


Thanks in advance!

 

[Hui]

Jaimee001


On the summary sheet you can use something like:

B2: =INDIRECT("Datasheet"&LEFT(B$1,3)&"!D22")

B3: =INDIRECT("Datasheet"&LEFT(B$1,3)&"!D23")

 

[Jaimee001]

Thank Hui...I'm not sure how that formula works. Would you mind explaining? When I put that formula on my summary tab I got a #REF error. Maybe I wasn't clear..instead of doing the 2 SUMIF formulas in each monthly tab, I want to do it on the summary tab (one in each line for each month). Does that make sense?

 

[Hui]

On the Summarysheet

B2:

=SUMIF(INDIRECT("DataSheet"&LEFT(B$1,3)&"!B2:B20"),"N",INDIRECT("DataSheet"&LEFT(B$1,3)&"!C2:C20"))

B3: =SUMIF(INDIRECT("DataSheet"&LEFT(B$1,3)&"!D2:D20"),"Y",INDIRECT("DataSheet"&LEFT(B$1,3)&"!C2:C20"))

Copy across

 

[Jaimee001]

Hui, you rock my world! Just when I think I have a handle on this excel thing, this group just BLOWS MY MIND!!!!! Thank you so much....I have much to learn...