Help with SUMPRODUCT and "does not equal" for non-numeric values

[bp32]

Hi,

I am trying to calculate SUMPRODUCT for all values that do not equal a single criteria (nyn). Here's the formula I have been using to caculate when the value does equal nyn:

=SUMPRODUCT(--('Raw Data'!$BK:$BK='NYN Data'!B1),--('Raw Data'!$H:$H="nyn"))

There are up to 30 separate values in H:H and I would like to alter the formula above so that it sums if H:H does not equal nyn.

Any ideas?

Thanks!

 

[Jonmo1]

You should be able to just change the

=
to
<>

 

[bp32]

Wow, that was too easy. Worked perfectly, thanks!