=SUM(COUNTIF(A1:A6,{"=3","4"})*{1,1})

You probably meant:

=SUM(COUNTIF(A1:A6,{"=3","4"})*{1,-1})

--
Biff
Microsoft Excel MVP


"Teethless mama" wrote in message
...
=SUM(COUNTIF(A1:A6,{"=3","4"})*{1,1})


"Ranjith Kurian" wrote:

I have a column called as COST as shown below, i need a excel formula to
pick
the data count from cost column to my count column based on Cost Range
column.
example:
Cost column
3
3.5
4
2
2.5
1

Cost Range column count column
4-3
2-1

Answer expected:

Cost Range column count column
4-3 3
2-1 3

Count column is nothing but it should count less than 4 and greater than
3
(3,3.5 and 4 are the answers)