don't know how to achieve that with SUMPRODUCT

but you might try:

=SUM(IF((B4:B87="New")*(A4:A87="PwC")*((C4:C87="Nu trition")+
(D4:D87="Nutrition")),1,))

insert it with CTRL+SHIFT+ENTER as it is an array formula

besides check yr data cause in C1 you have "NutItion" instead of
"NutRItion"



On 12 Gru, 15:01, KCR wrote:
Hello

I'm trying to figure out how to adapt a sumproduct formula so that i can
count the number of rows where, for example,

PwC is in column A
New is in column B
Nutrition *is in column C OR Nutrition is in column D

A * * * * * * *B * * * * * * *C * * * * * * *D
PwC * * * * *New * * * * Nutition * * Writing
Carer * * * *Return * * *Writing * * *Nutrition
PwC * * * * *New * * * * Writing * * *Nutrition

The answer should be 2 using the table above. I have been using this
sumproduct fomula to count where three variables occur, but can't see how to
adapt it.
=SUMPRODUCT(--(B4:B87="New"),--(A4:A87="PwC"),--(C4:C87="Nutrition"))

Help would be very much appreciated!

KC