SUMPRODUCT returns !Value#
The formula is SUMPRODUCT(('DR Kronos'!$B$4:$B$4878=A2)*('DR
Kronos'!$I$4:$I$4878="Project")*('DR Kronos'!$G$4:$G$4878))
"John C" wrote:
A formula would be quite helpful. Plus maybe some sample data :)
--
** John C **
"Dana" wrote:
I have a sumif function with two criteria so I used the sumproduct function,
but it returns the !Value# error? I can't figure out why?
|