Posted to microsoft.public.excel.misc

Hilton

external usenet poster

Posts: 35

Sumproduct - please add extra funtionality

Hi,

I need to use the sumproduct function but I would like to exclude 4
particular items which occur in a certain field

eg
SUMPRODUCT(($A$1:$A$1000 = FT)*($B$1:$B$1000 = 1)*($D$1:$D$1000))
works fine,

but now I need to exclude column C items which = RP, Sel, SP & Com

How do I do this?

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
extra command	jkf[_2_]	New Users to Excel	6	January 25th 08 03:11 AM
get rid of extra rows	kendallzemp	New Users to Excel	2	September 14th 07 05:55 AM
extra paper	Yvonne	Excel Discussion (Misc queries)	1	August 31st 07 03:02 AM
about extra row	jinvictor	Excel Discussion (Misc queries)	1	June 7th 06 02:24 PM
Loss of excel funtionality within IE	Dave Peterson	Excel Discussion (Misc queries)	0	October 25th 05 10:22 PM

All times are GMT +1. The time now is 10:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us