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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif 1
Date Range 2
Sumif across mutiple sheets 3
use month in cell date to sum all relevant cells 2
Sum with multiple conditions 6
Comparing more than two 4
Filtering / Dynamic Dashboard Question 5
SUMIFs function 2

Back
Top