A little help re: Count Formulas

[AndrewRossington]

What I need to do is count how many entries in a column have a cell on their respective row that meets a certain criteria.

Is there something like "sumproduct" but for counting... maybe "countproduct"? Or is it not that simple?

Any help would be much appreciated.

 

[lozzablake]

COUNTIF?

 

[AndrewRossington]

I thought Countif only checked criteria of cells you're counting...?

How could I get it to count one lot of cells whilst checking both the counted and an additional column?

 

[MarkAndrews]

vlookup?

or a combination of the two?

 

[Aladin Akyurek]

What I need to do is count how many entries in a column have a cell on their respective row that meets a certain criteria.

Is there something like "sumproduct" but for counting... maybe "countproduct"? Or is it not that simple?

Any help would be much appreciated.

What are the criteria and the ranges that must meet them?

 

[lozzablake]

It doesn't matter which column you count does it? The answer will be the same eg

apples 10
oranges 20
apples 10
lemons 40

If you want to count column B that has apples just do the countif on column a. It gives the same result (2). Or do you want to sum 10+10? In which case use SUMIF

 

[AndrewRossington]

What are the criteria and the ranges that must meet them?

I need to know how many cells in column E that have data in which also have a cell on the same row in column G with "Nursery" entered.

 

[njimack]

=SUMPRODUCT(--(E1:E1000<>""),--(G1:G1000="Nursery"))

 

[AndrewRossington]

=SUMPRODUCT(--(E1:E1000<>""),--(G1:G1000="Nursery"))

I've tried this but it's displaying NUM# in the cell.

Won't this formula sum the cells instead of count them?

 

[njimack]

Won't this formula sum the cells instead of count them?

No, since we didn't include a range to be summed.

Did I correctly understand your original question - you want to count every instance where column E contains data and column G contains the word "Nursery"?