1+1=??

[cgreen]

Hi All,

In column ‘U’ I have a link that enters a date when a project is completed. I am wanting to keep a count of completed projects, so I am using this formula “=IF(U3>0,"1","")” with the intentions of adding the 1 down the column to get a total. I entered a simple formula to get a total “=sum(AC3:AC47)”, the answer I get is “U”.

What am I doing wrong?

 

[Joe4]

Get rid of the quotes around the "1", it is making it Text instead of numeric:

=IF(U3>0,1,"")

You could also do this by using the COUNTIF function, then you wouldn't need this additional column (the IF statement is part of the COUNTIF function, see Excel help for details).

=COUNTIF(U3:U47,">0")

 

[Northerner]

=COUNTIF(AC3:AC47,"=1")

 

[GlennUK]

Well for a start off you shouldn't be putting the 1 inside quotes like "1" as this makes it a string instead of a number ( not very good for summing ).

Try changing that first, and see what happens.


Glenn.

 

[cgreen]

Works great!! It's amazing how something so simple can seem so hard.

Thanks

 

[RalphA]

Yes!

"What we know, seems easy; what we don't know, seems impossible"