COUNTIF AND COUNTIF
 

I have 2 conditions in 2 different ranges I want to compare

column A is last day
column B is sales

I want to count how many customers have not been in in 365 days and spent
more than 100 dollars
I tried =countif(a:a,"365") and countif(b:b,"100")
it's not working and thoughts

COUNTIF AND COUNTIF
 

Try SUMPRODUCT:

=SUMPRODUCT(--(A1:A100365),--(B1:B100100))

Note, you must specify the range. Adjust as needed.

HTH,
Paul

--

"Dave" wrote in message
...
I have 2 conditions in 2 different ranges I want to compare

column A is last day
column B is sales

I want to count how many customers have not been in in 365 days and spent
more than 100 dollars
I tried =countif(a:a,"365") and countif(b:b,"100")
it's not working and thoughts

COUNTIF AND COUNTIF
 

Hi,

You could also try this array formula (Ctrl+Shift+Enter)

=sum(if((range365)*(range2100),1))

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Dave" wrote in message
...
I have 2 conditions in 2 different ranges I want to compare

column A is last day
column B is sales

I want to count how many customers have not been in in 365 days and spent
more than 100 dollars
I tried =countif(a:a,"365") and countif(b:b,"100")
it's not working and thoughts