Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 3

Sumproduct but exclude labels

I am using the formula below and getting a #value error. I have determined
that it is because I have header rows within the rows 5 - 28. When I remove
those, the formula returns the correct value. However, I need to have the
head rows periodically though the data. Is there a way to write the formula
to both exclude negative values and "labels" ie. text?

MROUND(SUMPRODUCT((C5:C280)*(D5:D280)*(C5:C28)*( D5:D28)*(H5:H28)),5)

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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 exclude count	Dreamstar_1961	Excel Worksheet Functions	1	March 28th 07 03:03 AM
sumproduct exclude count	Dreamstar_1961	Excel Worksheet Functions	0	March 28th 07 02:46 AM
sumproduct exclude count	Teethless mama	Excel Worksheet Functions	0	March 28th 07 12:17 AM
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year)	Sam via OfficeKB.com	Excel Worksheet Functions	2	January 9th 07 12:37 AM
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year)	Sam via OfficeKB.com	Excel Worksheet Functions	10	January 8th 07 07:03 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us