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

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

AndrewRossington

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

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,209

ADVERTISEMENT

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

Well-known Member
Joined
Dec 15, 2005
Messages
818
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

Board Regular
Joined
Oct 27, 2005
Messages
114

ADVERTISEMENT

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

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
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"?
 

Forum statistics

Threads
1,136,366
Messages
5,675,351
Members
419,563
Latest member
blairtab

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
Top