Posted to microsoft.public.excel.worksheet.functions

adimar

external usenet poster

Posts: 49

Different comparison criteria in sumproduct

I'm looking for a formula that returns number of items delivered on time.
Ex: How many items "Apple" were delivered on time in the table below.

A B C
Item Requested Delivered
==== ========= =========
1 Apple 2/1/07 3/1/07
2 Apple 2/5/07 2/5/07
3 Orange 2/3/07 4/1/07
4 Apple 2/3/07 2/2/07
5 Apple 2/15/07 2/20/07

sumproduct(($A1:$5="Apple")*($B$1:$B$5=$C$1:$C$5)) doesn't work...

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
COUNTIF, criteria is cell-to-cell comparison	Jamie W	Excel Worksheet Functions	3	June 14th 07 07:31 PM
Sumproduct - two+ criteria	Bryce	Excel Worksheet Functions	2	February 7th 07 02:00 AM
SUMPRODUCT with 3 criteria	Kierano	Excel Discussion (Misc queries)	1	October 16th 06 05:16 PM
Sumproduct with 2 criteria	TMF in MN	Excel Worksheet Functions	3	February 27th 06 07:16 PM
Two cell Comparison with three different Criteria	[email protected]	Excel Worksheet Functions	8	December 28th 05 03:33 PM

All times are GMT +1. The time now is 11:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us