Posted to microsoft.public.excel.worksheet.functions

Deeds

external usenet poster

Posts: 113

Sumproduct #Value! Problem

Even better....thanks for the solution!

"Dave Peterson" wrote:

=SUMPRODUCT(--(Data!A70:A78=Sheet1!B72),Data!H70:H78)

With this syntax, text will be ignored/treated as 0.

deeds wrote:

I have a sumproduct formula that is returning #Value! when the range includes
cells with a "-" instead of a zero. How can I get around this so that it
treats the "-" like zeros? My formula:

=SUMPRODUCT((Data!A70:A78=Sheet1!B72)*(Data!H70:H7 8))

Thanks in advance

--

Dave Peterson

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	nada	Excel Worksheet Functions	4	April 3rd 08 09:17 AM
sumproduct problem	andy	New Users to Excel	2	March 29th 06 01:52 PM
sumproduct problem	christophe meresse	Excel Worksheet Functions	3	July 30th 05 02:23 PM
Another Sumproduct & #N/A problem	Dave Davis	Excel Worksheet Functions	3	January 10th 05 03:59 PM

All times are GMT +1. The time now is 01:27 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us