Sumproduct formula

[xxsalahxx]

Hi I have a sumproduct formula that works perfectly for what I need it to do, However id like to expand on it, from column K id like to extract "Yes" and "Unknown" replies, can anyone help with this formula?

=SUMPRODUCT((Data!$A:$A>='All Analysis'!A44)*(Data!$A:$A<='All Analysis'!B44)*(Data!$C:$C='All Analysis'!$D$43)*(Data!K:K="Yes"))

Any help is appreciated. thank you in advance

 

[Fluff]

Do you mean that col K will have "Unknown" in it & you want to include that in the count?

 

[xxsalahxx]

Yes please

 

[Fluff]

Ok, how about

=SUMPRODUCT((Data!$A:$A>='All Analysis'!A44)*(Data!$A:$A<='All Analysis'!B44)*(Data!$C:$C='All Analysis'!$D$43)*((Data!K:K="Yes")+(Data!K:K="Unknown")))

 

[xxsalahxx]

SUMPRODUCT((Data!$A:$A>='All Analysis'!A44)*(Data!$A:$A<='All Analysis'!B44)*(Data!$C:$C='All Analysis'!$D$43)*((Data!K:K="Yes")+(Data!K:K="Unknown")))

That works a treat, thank you and merry christmas

 

[Fluff]

Glad to help & thanks for the feedback.