View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default 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