Sorta. You need to use the SUMPRODUCT formula
Example of summing everything that corresponds to "tom" or "bob"
=SUMPRODUCT(((A2:A10="Tom")+(A2:10="Bob"))*(B2:B10)
Conditions in multiple columns (Bob in column A, Car in column C
=SUMPRODUCT((A2:A10="Bob")*(C2:C10="Car")*(B2:B10))
Similarly, a count of instances of Bob in column A, Car in column C
=SUMPRODUCT((A2:A10="Bob")*(C2:C10="Car"))
Or count in same column
=SUMPRODUCT(((A2:A10="Tom")+(A2:10="Bob"))
Note that you can't callout entire columns (A:A), and ranges must be the
same size.
Also, XL 2007 introduced SUMIFS and COUNTIFS, which allows multiple criteria.
Sorta. You need to use the SUMPRODUCT formula
Example of summing everything that corresponds to "tom" or "bob"
=SUMPRODUCT(((A2:A10="Tom")+(A2:10="Bob"))*(B2:B10)
Conditions in multiple columns (Bob in column A, Car in column C
=SUMPRODUCT((A2:A10="Bob")*(C2:C10="Car")*(B2:B10))
Similarly, a count of instances of Bob in column A, Car in column C
=SUMPRODUCT((A2:A10="Bob")*(C2:C10="Car"))
Or count in same column
=SUMPRODUCT(((A2:A10="Tom")+(A2:10="Bob"))
Note that you can't callout entire columns (A:A), and ranges must be the
same size.
Also, XL 2007 introduced SUMIFS and COUNTIFS, which allows multiple criteria.
If you are using xl2007, you can use SUMIFS, and COUNTIFS functions
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.
