Sumif with multiple criteria

  • Thread starter Thread starter TamIam
  • Start date Start date
T

TamIam

Good day,
I am hoping for some help solving an Excel problem. I have a sheet with
2006 data and another with 2007 data, both have identical layouts, however
may consist of different accounts with different products and volume. My
task is to provide a column on the 2007 sheet showing a variance from 2006 by
customer by product by volume. Any suggestions?
 
A pivot table or
to count
=sumproduct((a2:a22="joe")*(b2:b22=1))
to sum by criteria
=sumproduct((a2:a22="joe")*(b2:b22=1)*c2:c22)
 
Thanks, I have tried the Pivot Table, but the users find it difficult to
expand the data detail, so I said I would try to show it all on one line. I
will try the sumproduct.

Thanks again
 
Back
Top