Posted to microsoft.public.excel.worksheet.functions

John

external usenet poster

Posts: 2,069

SumProduct problem

How do I fix the following to sum the column & not get a #NAME? error?
=SUMPRODUCT(--(IsNumeric($D$10:$D$500)), --($D$10:$D$500))

I appreciate your help, -John

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
Sumproduct problem	burl_h	Excel Worksheet Functions	4	January 25th 09 07:30 PM
Problem with SUMPRODUCT	stevesoul	Excel Worksheet Functions	2	September 28th 08 03:20 AM
Problem with SUMPRODUCT....help please!	Tasha	Excel Worksheet Functions	5	July 16th 07 08:20 PM
SUMPRODUCT PROBLEM	laurie g	Excel Worksheet Functions	3	September 11th 06 05:00 AM
Sumproduct Problem	Andibevan	Excel Worksheet Functions	4	August 17th 05 09:39 AM

All times are GMT +1. The time now is 10:51 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us