Sumproduct
 

Yes you should. But I'll take a guess that a bunch of blanks now meet the
criteria. After all, 0 is probably < Dashboard!AD3, and blank activity types
also meet the < tests for each type of activity you're checking. So you may
just need to put some kind of qualifier in there to check for a legit date
(maybe even just 0).

"Ken" wrote:

A few days ago I received help with the following formula and it works fine

=SUMPRODUCT(('DATA (RAW)'!BH2:BH5000DASHBOARD!AD3)
*('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST")
*('DATA (RAW)'!N2:N5000<"WORK ORDER")
*('DATA (RAW)'!AQ2:AQ5000<"EMEA")
*('DATA (RAW)'!AQ2:AQ5000<"CALA")
*('DATA (RAW)'!AQ2:AQ5000<"NA"))

That said... when I try to use the same formula with the < it doesn't work.
Should I not be able to do the following?

=SUMPRODUCT(('DATA (RAW)'!BH2:BH5000<DASHBOARD!AD3)
*('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST")
*('DATA (RAW)'!N2:N5000<"WORK ORDER")
*('DATA (RAW)'!AQ2:AQ5000<"EMEA")
*('DATA (RAW)'!AQ2:AQ5000<"CALA")
*('DATA (RAW)'!AQ2:AQ5000<"NA"))

Appreciate the help.

Ken

Sumproduct
 

Thanks again ... that worked! Say is there anyway I can just download what
you know so I don't have to keep bothering you?

This worked

=SUMPRODUCT(('DATA (RAW)'!BH2:BH5000<DASHBOARD!AD3)
*('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST")
*('DATA (RAW)'!N2:N5000<"WORK ORDER")
*('DATA (RAW)'!AQ2:AQ5000<"CALA")
*('DATA (RAW)'!AQ2:AQ5000<"ASIA")
*('DATA (RAW)'!AQ2:AQ5000<"EMEA")
*('DATA (RAW)'!AS2:AS5000<"CA")
*('DATA (RAW)'!BH2:BH5000<0))

"bpeltzer" wrote:

Yes you should. But I'll take a guess that a bunch of blanks now meet the
criteria. After all, 0 is probably < Dashboard!AD3, and blank activity types
also meet the < tests for each type of activity you're checking. So you may
just need to put some kind of qualifier in there to check for a legit date
(maybe even just 0).

"Ken" wrote:

A few days ago I received help with the following formula and it works fine

=SUMPRODUCT(('DATA (RAW)'!BH2:BH5000DASHBOARD!AD3)
*('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST")
*('DATA (RAW)'!N2:N5000<"WORK ORDER")
*('DATA (RAW)'!AQ2:AQ5000<"EMEA")
*('DATA (RAW)'!AQ2:AQ5000<"CALA")
*('DATA (RAW)'!AQ2:AQ5000<"NA"))

That said... when I try to use the same formula with the < it doesn't work.
Should I not be able to do the following?

=SUMPRODUCT(('DATA (RAW)'!BH2:BH5000<DASHBOARD!AD3)
*('DATA (RAW)'!N2:N5000<"SUPPORT REQUEST")
*('DATA (RAW)'!N2:N5000<"WORK ORDER")
*('DATA (RAW)'!AQ2:AQ5000<"EMEA")
*('DATA (RAW)'!AQ2:AQ5000<"CALA")
*('DATA (RAW)'!AQ2:AQ5000<"NA"))

Appreciate the help.

Ken