Count formula?

[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?

 

[Frank Stone]

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

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

 

[Domenic]

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

Hope this helps

 

[Ian]

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

 

[Alex Delamain]

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

 

[Ian]

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 Sweeney]

None of them worked.. any other ideas?

 

[Alex Delamain]

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