sumif on multiple sheets

  • Thread starter Thread starter Randall Roberts
  • Start date Start date
R

Randall Roberts

use this

=SUM(SUMIF(INDIRECT("Sheet"&{1,2}&"!A1:A7"),"name",INDIRECT("Sheet"&{1,2}&"!B1:B7")))

add sheet numbers as needed and replace name with the name you want
 
I have 12 different worksheets which has sales for the month. On each
worksheet the individual sales people are ranked by percentage so each and
every sheet will not be in the same order.

What I need is to sum the Year to date total sales of all the salespeople on
a Year to date sheet. Can I use the sumif on all the sheets at the same
time.

Can anyone help


Thanks

Fawn
 
Back
Top