LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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")
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compare worksheets Lise Excel Discussion (Misc queries) 4 July 9th 09 01:56 AM
Need to compare 2 worksheets... Bonnie Excel Discussion (Misc queries) 3 December 2nd 08 11:06 AM
Compare two worksheets Patricia Martinez Excel Worksheet Functions 0 October 5th 07 12:01 AM
compare worksheets klafert Excel Discussion (Misc queries) 6 January 15th 07 02:17 AM
Compare two worksheets rageon75 New Users to Excel 5 February 24th 06 05:01 PM


All times are GMT +1. The time now is 12:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"