Count formula?

  • Thread starter Thread starter Kyle Sweeney
  • Start date Start date
K

Kyle Sweeney

I have some cells that i need to do a count on.
I can do the count formla but i can not do a specific count.

I have some cells and I only want it to do a count on the cells that has a
number above 200.

Can someone help?
 
hi,
use the countif formula. you can look it up in help.

=countif("range",>200)
Regards
Frank
 
Hi

In a similar vein how do I SUM conditionally, I've tried SUM(IF(... and now
I am being driven nuts by the conditional sum wizard. Here is the info...

sheet of dates with payments
I want quarterly totals (my start date is 1-June not 1-Jan)

Thanks
Ian
 
Column A has dates, Column B has payments

C1 = start date, D1=end date

=sumproduct((a1:a100>=C1)*(a1:a100<=D1)*(B1:B100))

This will total payments between start and end dat
 
I was using constants in the places you have C1 and D1 and getting a real
mess. I'll try this way.

Thanks Ian
 
Kyle
I have tried the formulae and they do work!
I suggest you check how you have entered them and how your data i
formatted.

=COUNTIF(A1:A10,">200")

The countif formula needs to be entered as above to work so try copyin
and pasting it. You should also check that your data is formatted a
numbers - it will ignore any text.
Failing that please post a selection of your data and the formula an
we will have another look
 
Back
Top