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.
=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.