A little help re: Count Formulas

AndrewRossington

Board Regular
Joined
Oct 27, 2005
Messages
114
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.
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
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?
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
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"?
 
Upvote 0

Forum statistics

Threads
1,217,498
Messages
6,136,988
Members
450,037
Latest member
Tao86

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top