Thread
:
SUMPRODUCT that contains multiple criteria
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
SUMPRODUCT that contains multiple criteria
Define "contains". Do you mean only 7 or only 16 in col B or aaaa7bbb
aaa16bbb
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Sarah (OGI)" wrote in message
...
I have written the following formula, but an #N/A value is being returned.
=SUMPRODUCT(--(YTD!$B$2:$B$65536={"*7*","*16*"}),--(YTD!$AB$2:$AB$65536))
I am trying to sum the cells in column AB where the cell in column B
contains either a 7 or a 16.
Please could someone advise if I need to make a correction to the existing
formula, or if I should be using a different function altogether.
Many thanks in advance.
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett