| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Min Sumproduct formula returns a zero. | Excel Discussion (Misc queries) | |||
| SUMPRODUCT returns 0, when I know it shouldn't | Excel Worksheet Functions | |||
| SumProduct Returns Zero | Excel Worksheet Functions | |||
| sumproduct returns zero | Excel Worksheet Functions | |||
| returns calculation using sumproduct | Excel Worksheet Functions | |||
Hybrid Mode
