Make sure all your ranges have the size


"Iona" wrote:

Hello to all of you Excel Experts,

HELP, pretty please.

I have 2 formulas I am trying to combine. I had to break them out, to try
and troubleshoot my initial error, #Name?


Both of these formulas worked, but I need them combined. I am pulling from a
different worksheet and working in Excel 2003. I am trying to identify in one
column (Column A) the site visits along with another column (Column E)
looking for a date range of 09/01/08 - 09/30/08. The issue is I have to do a
search because for some reason the names in Column A (Site Visits) were not
picking up when I had the formula combined.

=SUMPRODUCT(--(ISNUMBER(SEARCH('Project KPI Detail'!A15:A35,"Construction
Start"))))

=SUMPRODUCT(--(YEAR('Project KPI
Detail'!$E$16:$E$37)=2008),--(MONTH('Project KPI Detail'!$E$16:$E$37)=9))

Thank you,
The Novice