SUMPRODUCT that contains multiple criteria
You can't use wildcards in this situation, but as you have only got
one criterion, you could use SUMIF which does support wildcards:
=SUMIF(YTD!B:B,"*7*",YTD!AB:AB) + SUMIF(YTD!B:B,"*16*",YTD!AB:AB)
Hope this helps.
Pete
On Sep 2, 9:57*am, Sarah (OGI)
wrote:
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.
|