SUMPRODUCT returns !Value#
 

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?

SUMPRODUCT returns !Value#
 

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?

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?

SUMPRODUCT returns !Value#
 

If you've got a value error, at least one of the cells in your range in
column G contains text, rather than a number.
--
David Biddulph


"Dana" wrote in message
...
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?

SUMPRODUCT returns !Value#
 

That was the problem. I removed the text and it worked.

Thanks you very much.

"David Biddulph" wrote:

If you've got a value error, at least one of the cells in your range in
column G contains text, rather than a number.
--
David Biddulph


"Dana" wrote in message
...
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?

SUMPRODUCT returns !Value#
 

This syntax will ignore text:

=SUMPRODUCT(--('DR Kronos'!$B$4:$B$4878=A2),--('DR
Kronos'!$I$4:$I$4878="Project"),'DR Kronos'!$G$4:$G$4878)


--
Biff
Microsoft Excel MVP


"Dana" wrote in message
...
That was the problem. I removed the text and it worked.

Thanks you very much.

"David Biddulph" wrote:

If you've got a value error, at least one of the cells in your range in
column G contains text, rather than a number.
--
David Biddulph


"Dana" wrote in message
...
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?