SUMIF Statament Across Columns

[DaveMitch]

Hi,

Not sure if I'm being a bit thick, but I'm not sure if I'm using SUMIF in the correct way to achieve what I need.

What I have is this: =SUMIF(J44,"Y",K44:M44)

...where column J either has a 'Y' or a 'N' in and K44:M44 has a number in it; like this it returns, -

If I change K44:M44 to a single cell it adds it up! I thought I understood how SUMIF works, but clearly not; can someone help give me illumination.

Many thanks in advance.

 

[AhoyNC]

In the SUMIF both your criteria and sum range need to be the same size / length.
Try:

=IF(OR(J44={"Y","N"}),SUM(K44:M44),"")

 

[DaveMitch]

Hi AhoyNC,

Sorry for the delay in feedback. Many thanks for this solution, it works perfectly. Most importantly, thank you for explaining SUMIF, I never knew that, it will help prevent similar frustrations in the future!

Having looked up what OR does I can read your formula, apart from the use of { }, I don't know what that type of brackets do?

Many thanks again.

 

[AhoyNC]

You're welcome. I just used the{} to shorten the formula a little.
OR(J44={"Y","N"}) is the same as OR(J44="Y",J44="N")

 

[DaveMitch]

Hello again,

I see...or at least I think I do! So much to learn.....

Thanks again.