Count range

[craig.jenkins]

Hi All

I have a column which has something simular to the below:

1
2
0
0
0
0
5
4
3

I want to be able to count the amount of values in the column including the Zeros so the formula for the above should say '9'.

Can this be done?

Many thanks

[EdMac]

Hi Craig

You need to use COUNTIF

=COUNTIF(A2:A12,">=0")

Replace A2:A12 with your range

Ed

[craig.jenkins]

Thanks mate,

Is it possible to also do the same thing but not include the zeros in the calculation?

Craig.

[EdMac]

Sure,

Just change the criteria as below

=COUNTIF(A2:A12,">=1"

Will count all greater than or equal to one

Ed

[EdMac]

bwhizz,

suggest you start your own new thread. That said, it looks like you really need to change your data layout to make a solution easy to find.

Tyr posting a copy of your sheet with your new thread.

Ed

[bwhizz]

Hoping to get some help with this one.... I have a sheet of data and want to count how many oranges I have in total. I need to create a formula that counts the number of oranges. Keeping in mind that Cells C14, C30, C42 and C50 might change at any given time.

How do I create an if statement that counts the number of fruits if Cells C14,C30, C42 and C50 = Orange?

The Values of the fruits are always in Column G, one row under the row with the fruit

Cell C 14 Orange
Cell G15 3
Cell C30 Pear
Cell G31 5
Cell C 42 Apple
Cell G43 6
Cell C50 Orange
Cell G 51 8


Hope this makes sense
Thanks!