Thread
:
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
Harry Seymour[_2_]
external usenet poster
Posts: 9
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
very useful!
what is the -- function for??
"Bob Phillips" wrote:
=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Harry Seymour" <Harry
wrote in message
...
How can I sum values in my third column by specifying conditions in my
first
two?
e.g. Column A has values "Jon", "Max", "Mary", "Tom"
Column B has values "A" and "B".
Column C has values for each.
I need to sum C values where column A shows "Jon" and column B shows "B".
I've tried =sumif(AND(A1:A10, "Jon"),(B1:B10, "B"), C1:C10) with no luck.
the usual sumif should have the format =sumif(range to be assessed,
Criteria, range to be summed)
Reply With Quote
Harry Seymour[_2_]
View Public Profile
Find all posts by Harry Seymour[_2_]