Posted to microsoft.public.excel.misc

Mark Allen Mark Allen is offline

external usenet poster

Posts: 54

Sum Product maybe??

I have the following spread sheet that I need to calculate the value of if "Y"

A B C D
Sold Product Value Date
Y Hardware $20.00 Jan-09
Y Software $50.00 Feb-09
N Hardware $50.00 Jan-09

Ok, so I want to know the "value" of the Hardware items sold "Y" in Jan-09.

Do I use SUMPRODUCT

Hope some one can help please.

Regards

Mark

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
=PRODUCT	billy-bob	Excel Discussion (Misc queries)	6	August 4th 08 12:10 PM
What is sum product...	Srikanth	Excel Discussion (Misc queries)	8	November 28th 07 11:28 AM
Sum product	Virginia	Excel Discussion (Misc queries)	3	April 10th 07 10:13 PM
Sum product	HJ	Excel Worksheet Functions	6	February 16th 06 06:05 PM
Sum Product	HJ	Excel Worksheet Functions	4	October 27th 05 11:32 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us