sumif

  • Thread starter Thread starter Fawn
  • Start date Start date
F

Fawn

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
 
Hi Fawn
SUMIF does not support 3D references for multiple sheets. One
workaround: Use separate SUMIFs per sheet and add them
 
Back
Top