Hi,

I am trying to SUMIF some statistics in a column when the range contains a certain two-letter abbreviation.


My equation is as follows =SUMIF(Y409:Y3, "MC", AA409:AA3)

This should be simple enough, sum the figures in cells AA409:AA3 if the range (Y409:Y3) contains the words "MC" or similar two letter abbreviation.

Any ideas why excel is displaying the error?

Many thanks!