SUMIF issues

Hi,

I'm trying to do the following

If Cell D11 is greater than zero than sum cells E11:L11

I've tried the following formula;

=SUMIF(D11,">0",E11:L11)

But its only returning the value from cell E11

Would really appreciate any help with this.

Thanks

Ian

To do 'exactly' what you wrote here.

Originally Posted by ian_a91

If Cell D11 is greater than zero than sum cells E11:L11

That would be =IF(D11>0,SUM(E11:L11),"")

You didn't specify what to do if D11 is NOT greater than 0, so I just made it return "".

Thanks for the help guys was going round in circles a bit

thanks again

Ian

You're welcome.