Posted to microsoft.public.excel.misc

Ben010

Posts: n/a

Conditional Sum Product

I want to get the sumproduct of two rows of numbers based on an IF condition
in a related row. The formula would look like this:
=Sumproduct(a2:z2, a3:z3)* Multiplier if a1:z1="Yes", otherwise Multiplier =1
So if a1="Yes" then the product would be a2*a3*M; if b1<"Yes" then the
product would be b2*b3*1. Any ideas?

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
Conditional formatting - Find common material	kuansheng	Excel Worksheet Functions	9	March 31st 06 07:36 PM
Conditional Format Not Working	KMH	Excel Discussion (Misc queries)	0	December 22nd 05 05:32 PM
Percentages	Darryl	Charts and Charting in Excel	2	May 21st 05 04:31 PM
How to set a formula to count the product appear how manytime	AMY	Excel Worksheet Functions	3	March 21st 05 09:49 AM
Which function(s)?	LB	Excel Worksheet Functions	3	January 5th 05 06:19 PM

All times are GMT +1. The time now is 12:00 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us