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.
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.