Newbie Excel Help needed

[gpick24]

Hi all.
I'm new to excel formulas but i've been having a play with the "IF" formula.
Heres the formula i'm trying to use.
=IF(F18<0,"1","")
This goes in cell G18.
What I want to do is place the number 1 in G18 if F18 is less than zero.
This then repeats for a number of cells and I want to end with adding the 1's with autosum.
Everything works except the adding with autosum.
All the 1's are there but the autosum shows 0.
Any help please,
GPick.

[ken]

Hi all.
I'm new to excel formulas but i've been having a play with the "IF" formula.
Heres the formula i'm trying to use.
=IF(F18<0,"1","")
This goes in cell G18.
What I want to do is place the number 1 in G18 if F18 is less than zero.
This then repeats for a number of cells and I want to end with adding the 1's with autosum.
Everything works except the adding with autosum.
All the 1's are there but the autosum shows 0.
Any help please,
GPick.
The problem with your formula is that you've written the 1 as a string rather than a number, delete the "s that I've coloured red and it will work fine.

Basically with the quote signs you've added you're trying to sum text instead of numbers.

It should look like this:
=IF(F18<0,1," ")

[gpick24]

Thanks, will try that.
GPick.

[gpick24]

Worked a treat, thanks a lot.

[ken]

You're welcome :tup: