Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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") |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare worksheets | Excel Discussion (Misc queries) | |||
Need to compare 2 worksheets... | Excel Discussion (Misc queries) | |||
Compare two worksheets | Excel Worksheet Functions | |||
compare worksheets | Excel Discussion (Misc queries) | |||
Compare two worksheets | New Users to Excel |