Sum rows where dollar amount is greater than zero

[cuetzpalin]

Hello,

I have a spreadsheet with over 1000 rows and one of the columns is a dollar amount. Not all rows have a dollar amount greater than zero. What I'm trying to do is count all the rows that have a dollar amount. Can you help me please?

Thanks!
Ed

 

[SkipVought]

Hi,

Check out the SUMIF function.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cckens]

I would do a count on all the column rows. Nest an if statement in the COUNT (XXX) area and that should take care of your problem. That should give you the number you need.
I'd give you exact details, but I'm OoO on mobile and can't get to Excel.
Hope this helps
cckens

 

[cuetzpalin]

I figured it out! I used the COUNTIF function....

basically looks like this...

COUNTIF(B2:B1501,">0")

Thanks for the responses!

 

[SkipVought]

Sorry, I refered your to SUMIF when you needed COUNTIF (same IFy principle ;-) )

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[AnotherHiggins]

In your defense, Skip, the Title of the thread is "Sum rows where dollar amount is greater than zero".

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.