sumif

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
 
F

Frank Kabel

Hi Fawn
SUMIF does not support 3D references for multiple sheets. One
workaround: Use separate SUMIFs per sheet and add them
 
Top