Posted to microsoft.public.excel.misc

Mitch

Posts: n/a

I need a productif type function

I want to search a range of cells, say C:C for a value, if that value is
there i want to multiply the corresponding B cell and D cell together then
sum up all of the true values. If anyone can help me please let me know.

Thanks

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
Creating a Custom Excel Function to Calculate Gini Coefficients	[email protected]	Excel Worksheet Functions	3	February 21st 06 10:15 PM
multiple results display after filter function	Morphyus C via OfficeKB.com	Excel Worksheet Functions	1	August 11th 05 03:17 PM
Automatically up date time in a cell	Mark	Excel Discussion (Misc queries)	5	May 12th 05 12:26 AM
clock	Wildman	Excel Worksheet Functions	2	April 26th 05 10:31 AM
Is there a WorkDay() type function that count all days except tho.	Dark Skunk	Excel Worksheet Functions	8	February 15th 05 08:37 PM

All times are GMT +1. The time now is 02:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us