sumif

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

Fawn

Is is possible to use the formula Sum(start:end!b1) with a condition.

What I want to do is sum anything between the sheets start and end that
match a criteria.

I have 12 different sheets which recaps the sales revenue per sales person.
Each and every one of the sheet the salepeople are not in the same order.
So what I am trying to do is sum the sheets if the criteria matches the
master sheet.

Please let me know if this is possible. Right now I have them sum using
name ranges.

Thanks for your help

Fawn
 
Fawn said:
Is is possible to use the formula Sum(start:end!b1) with a condition.
Click to expand...
....

Not using 3D references. If you put all worksheet names between start and
end (inclusive) in a single column range named wslist, you could use

=SUMPRODUCT((N(INDIRECT("'"&wslist&"'!B1"))>0)
*N(INDIRECT("'"&wslist&"'!B1")))

to sum only positive values.
 
Back
Top