Date function

  • Thread starter Thread starter Denise Ch'ng
  • Start date Start date
D

Denise Ch'ng

I have two sheets in an excel workbook, one named 'Main
Audits' and the second named report spreadsheet.

What I want to do is to put the month number into cell H1
in 'Report spreadsheet' (example 9 for September), and
want to count how many RFX audits were completed in
September.

The info applicable in 'Main Audits' consists of whether
is is a RFX (in row C) and the date (in row H). I have the
following formula...however it is not working...can you
help?

=COUNT(IF(('Main Audits'!$C$18:$C$117="RFX")*('Main
Audits'!#REF!='Report spreadsheet'!$H$1),'Main Audits'!
#REF!))
 
If I understand you right, try:
=SUMPRODUCT(('Main Audits'!$C$18:$C$117="RFX")*(MONTH('Main
Audits'!$H$18:$H$117)='Report spreadsheet'!$H$1))

(untested)
Bob Umlas
Excel MVP
 
Back
Top