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
|