function to match and count specific numbers in a range

**Karnik** · 06-19-2016, 04:34 AM

Hi Expert,

Wondering simple function is possible using match and count in a given range (a1:g7) :-
Given row range (a1:g7)each cell numbers are
2,20,38,29,6,8, 10

need to count specific numbers only 2,20,29 answer is 3

Thanks
Karnik

**JohnTopley** · 06-19-2016, 04:36 AM

Try

=SUM(COUNTIF(A1:G1,{2,20,29}))

**Karnik** · 06-19-2016, 04:58 AM

Hi John,
Thanks for solution, it work!
I was using if& lengthy one, this is excellent
Thanks
Karnik

**Tony Valko** · 06-19-2016, 06:29 AM

Here's another one...

Use cells to hold the criteria.

Data Range

	A	B	C	D	E	F	G	H	I	J
1	43	41	67	77	16	95	5		2	3
2	2	24	31	14	15	62	66		20
3	30	99	69	41	10	77	35		29
4	97	77	86	20	24	25	79
5	94	33	69	62	43	86	92
6	89	59	64	67	94	1	87
7	19	79	74	46	86	56	29
8	----	----	----	----	----	----	----	----	----	----

This formula entered in J1:

=SUMPRODUCT(COUNTIF(A1:G7,I1:I3))

**Karnik** · 06-19-2016, 06:36 AM

Hi Tony,
Thanks , it works too!
Karnik

**Tony Valko** · 06-19-2016, 06:42 AM

You're welcome. Thanks for the feedback!

function to match and count specific numbers in a range

LinkBack

Thread Tools

Rate This Thread

Display

function to match and count specific numbers in a range

Re: function to match and count specific numbers in a range

Re: function to match and count specific numbers in a range

Re: function to match and count specific numbers in a range

Re: function to match and count specific numbers in a range

Re: function to match and count specific numbers in a range

Thread Information

Users Browsing this Thread

Similar Threads

Find and count specific numbers in a range of cells

[SOLVED] Function possible for Using specific number to count other specific numbers total ?

Count cells in a range that match a specific criteria in a different cell range

Count number of colums that cantains numbers from a specific range

count numbers in specific range

Count the number between specific Range of numbers

Match a combination of numbers in a range with a Specific Number

Bookmarks

Bookmarks

Posting Permissions