Summing Values using multiple criertia

J

Jane

Does anybody know a formula I could use to sum a range of
values based on multiple criertia?

Example:

Division Type Wage
Bulk Driver 200.00
Bulk Admin 400.00
General Admin 500.00
Bulk Driver 100.00

I want to sum the wages for Divison "Bulk" &
Type "Driver". How can I do this???

Thanks!
Jane
 
M

Myrna Larson

=SUMPRODUCT((A2:A4="Bulk")*(B2:B4="Driver")*(C2:C4))

If there are lots of such totals, you may want to consider a pivot table
rather than formulas.
 
B

Biff

Ooops!

I think that was a result of a line wrap that I tried to
correct!

Yes, the double unary is needed.

Biff
-----Original Message-----
Hi, Biff:

Don't you need two minus signs in front ot the 2nd criterion, too?
Click to expand...
 

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

Keep getting #### when summing numbers 2
Sum Column Entries that fall within Date Range Listed In Rows 4
Summing rows using formulas with variables 1
summing across worksheets conditionally and being able to copy for 4
Need help with lookup & sum range 2
Using H/VLOOKUP to return multiple values 2
SUM with Multiple Criteria 2
complex count formulas using multiple criteria in different ranges 4

Top