Posted to microsoft.public.excel.misc

sdg8481

external usenet poster

Posts: 29

SUMPRODUCT IF query

Hi,

I've been tring to add an extra IF statement into the following query but
can't figure out how, what i want is for a count to be returned if cell A2 on
sheet2 is the same as sheet1 where the M colunm in Sheet 1 = "on Time", but
also where the N column on sheet1 = "EXEMPT".

=SUMPRODUCT(--(Sheet1!M2:M11="On Time"),--(Sheet1!F2:F11=Sheet2!A2))

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
SUMPRODUCT/HLOOKUP Query	luvthavodka	Excel Discussion (Misc queries)	6	July 15th 06 06:58 PM
SUMPRODUCT Query	penri0_0	Excel Discussion (Misc queries)	7	June 7th 06 12:22 PM
Sumproduct Query	shakey1181	Excel Discussion (Misc queries)	6	June 7th 06 11:56 AM
I think its a sumproduct query?	Scoosh	Excel Discussion (Misc queries)	0	September 8th 05 12:45 AM
SUMPRODUCT(-- Query for Tom Oglivy or others......	marika1981	Excel Discussion (Misc queries)	4	February 21st 05 07:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us