Posted to microsoft.public.excel.programming

Jimish

external usenet poster

Posts: 21

sumproduct and if

i have a file with 4 cols. say
desc weight rate a rate b

now i want to get sumproduct of col weight and rate a only if there is
any value in rate b. i got sum of col weight only of those col where
there there is value in rate b. so how to solve this problem

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
Help with SumProduct	Ayo	Excel Worksheet Functions	7	March 18th 10 12:21 AM
Sumproduct with Condition OR Sumproduct with ADDRESS function - HE	gholly	Excel Discussion (Misc queries)	2	September 28th 09 05:07 PM
sumproduct	[email protected]	Excel Worksheet Functions	2	March 25th 09 12:47 PM
Conditional SUMPRODUCT or SUMPRODUCT with Filters	Ted M H	Excel Worksheet Functions	4	August 14th 08 07:50 PM
sumproduct? sumif(sumproduct)?	David	Excel Worksheet Functions	3	July 13th 07 07:06 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us