SUMPRODUCT with multiple variables

Joined
Jul 6, 2010
Messages
1
Reaction score
0
I am trying to use SUMPRODUCT to add values based on two different criteria. The first is a simple text match, which I have working well, but the second is where I am getting tripped up. I would like to match the value of a specific cell, but it is formatted as a date. Here is the current function:

=SUMPRODUCT(--('Raw Leads'!C2:C257="lease"),--('Raw Leads'!E2:E257='Listing and Lead Report'!BZ3)--('Raw Leads'!F2:F257))

The column E on worksheet 'Raw Leads' has the same date format as BZ3.

I have already tried using a value expressed as DATE, or two separate arrays using MONTH and DAY to no success.

Any thoughts would be greatly appreciated.
 
Back
Top