CountIf on 2 columns

[JC]

I have 2 columns of data, Profit $ and Profit %. I would
like to get a grouping of different counts. For example,
the number of items with Profit $ > 500 and Profit %

.50, down to the items with Profit $ <5 and Profit %

< .10 and various groups in between.

I can get the data for one column using COUNTIF but how
do I do it for 2 columns?

TIA,
JC

 

[Aladin Akyurek]

=SUMPRODUCT(--(ProfitDollarRange>X2),--(ProfitPercentageRange>Y2)

X2 houses a dollar value like 500 and Y a percentage value like 0.50.

 

[Frank Kabel]

Hi
try SUMPRODUCT. e.g.
=SUMPRODUCT(--(A1:A100>500),--(B1:B100>0.5))

 

[JRunner]

I have been able to make this work if I am using just a greater than o
less than criteria. How can I do this if I am trying to find a
interior range. Something like, how many items have a Profit betwee
$250 and $500 and a profit margin between 10% and 50%. I have tried
number of options with no success

 

[Frank Kabel]

Hi
try
=SUMPRODUCT(--(A1:A100<500),--(A1:A100>250),--(B1:B100>0.1),--(B1:B100<
0.5))