View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
daddylonglegs daddylonglegs is offline
external usenet poster
 
Posts: 174
Default counting numbers not formulas

If they haven't donated yet what do you have in the cell, a zero or a blank?
If it's the latter perhaps you can just use

=COUNT(range)

or for the former

=COUNTIF(range,"0")

"Kit M" wrote:

I need to count the number of people who have donated to my fundraiser. If
they have already donated, the amount is displayed in a "Total donations"
column that adds up multiple donations from across the row. If they haven't
donated yet, there is a formula in that cell. No cell is blank and all the
formulas I try won't count just the cells with a dollar amount. Where am I
going wrong?

Thanks,

Kit