Thread: Formulas that compare and sum between worksheets
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Pat Pat is offline
external usenet poster
  
Posts: 210
Default Formulas that compare and sum between worksheets
I need a formula to look at column AF to compare the date, then look at
column N for the work "rejected" then sum the total rejected's between 3
spreadsheets, and enter the output on sheet 5. I have one formula so far, but
can't seem to figure how to add the comparison for the date:
=COUNTIF(Projects!N:N,"REJECTED")+COUNTIF(AR!N:N," REJECTED")+COUNTIF(Legal!N:N,"REJECTED")
Reply With QuoteReply With Quote