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