Sadly, I'm still getting a zero result which is wrong....any suggestions? Thx!

"Barb Reinhardt" wrote:

I'd try this:

=SUMPRODUCT(--('Labor Download'!$O$2:$O$12000=Report!$A$6),--('Labor
Download'!$I$2:$I$12000='Labor Report'!R15),('Labor Download'!$K$2:$K$12000))


"Ang" wrote:

Labor download column O = day of month
ReportA6=day of month

Labor download column I = department
Labor report columnR -= department

Labor download column K = dollars

(SUMPRODUCT(('Labor Download'!$O$2:$O$12000=Report!$A$6)*('Labor
Download'!$I$2:$I$12000='Labor Report'!R15)*('Labor Download'!$K$2:$K$12000)))


same formula but different column ref for hours

Help?

"Don Guillett" wrote:

Might help to post your formula

--
Don Guillett
SalesAid Software

"Ang" wrote in message
...
I have a formula using SUMPRODUCT which was working and, unfortunately, is
no
longer working and I don't know why. Instead of real values, all I get
now
is all zeros. I haven't changed the formula. The data sheet where the
info
is, changes daily but shouldn't affect my formula, correct? I looking at
HELP in Excel and I'm wondering if this has anything to do with my issue:

SUMPRODUCT treats array entries that are not numeric as if they were
zeros.

Any ideas out there on why this wouldn't be working any longer?
Thx for your expertise!