Posted to microsoft.public.excel.misc

vezerid

Posts: n/a

sumif problems

#1:
=SUMPRODUCT(--($A$2:$A$10<"S"),D2:D10)

#2:
=SUMPRODUCT(--($A$2:$A$10<"S"),D2:D10+E2:E10)

HTH
Kostis Vezerides

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
Sumif problems - meeting 2 criteria then sum	Kikkoman	Excel Discussion (Misc queries)	1	August 2nd 05 04:49 PM
problems with sumif and countif	Simon Shaw	Excel Discussion (Misc queries)	6	July 23rd 05 10:02 PM
Problems with SUMIF function and Wildcards (* and ?)	J1J	Excel Worksheet Functions	4	June 27th 05 04:25 PM
Sumif Problems	Anat	Excel Discussion (Misc queries)	6	June 16th 05 06:05 AM
sumif alphanumeric problems	buyer1	Excel Discussion (Misc queries)	4	February 1st 05 10:10 PM

All times are GMT +1. The time now is 11:08 AM.

About Us

"It's about Microsoft Excel"