Posted to microsoft.public.excel.worksheet.functions

Dana

external usenet poster

Posts: 45

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Min Sumproduct formula returns a zero.	checkQ	Excel Discussion (Misc queries)	2	May 10th 08 08:06 PM
SUMPRODUCT returns 0, when I know it shouldn't	Tim Bridle	Excel Worksheet Functions	5	January 20th 07 04:03 PM
SumProduct Returns Zero	ronnomad	Excel Worksheet Functions	4	August 10th 06 02:45 PM
sumproduct returns zero	vacation	Excel Worksheet Functions	7	January 31st 06 07:56 PM
returns calculation using sumproduct	Stan Altshuller	Excel Worksheet Functions	6	January 13th 05 12:25 AM

All times are GMT +1. The time now is 05:31 PM.

About Us

"It's about Microsoft Excel"