Posted to microsoft.public.excel.newusers

robot

external usenet poster

Posts: 6

SumProduct problem

Hello,

One of the ranges I use in my sumproduct formula includes cells with formula
like

=IF(A1=0, "", A1)

The sumproduct returns a #VALUE! error whenever the cell A1 is 0, otherwise
it works fine.

How to deal with the problem by modifying the sumproduct ?
(The formula IF(A1=0, "", A1) is fixed and cannot be modified)

Any suggestions would be appreciated. I use Excel XP. Thanks.

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
Problem using SUMPRODUCT	JoAnn	New Users to Excel	1	April 22nd 08 08:57 PM
SUMPRODUCT problem	juliejg1	Excel Worksheet Functions	4	January 30th 08 08:43 PM
SUMPRODUCT problem	Joe M.	Excel Discussion (Misc queries)	6	January 30th 08 04:44 PM
sumproduct problem	Stefan	Excel Worksheet Functions	2	January 5th 06 10:59 AM
SUMPRODUCT problem	Jane	Excel Worksheet Functions	3	November 8th 04 11:58 PM

All times are GMT +1. The time now is 12:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us