Re: V Look Up more than one result
From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 08/23/04
- Next message: Andy Brown: "Re: How to determine formula or simple value in a cell?"
- Previous message: Aladin Akyurek: "Re: Want To Count With Two Criteria"
- In reply to: JavyD: "V Look Up more than one result"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 23 Aug 2004 21:14:52 +0100
=sumproduct(--(B1:B100=1234),--(D1:D100=--("2004-08-23")),c1:c100),
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"JavyD" <JavyD@discussions.microsoft.com> wrote in message
news:D1DB0781-99AC-4B0F-ABEF-1344194A1386@microsoft.com...
> Hello guys this is my problem.
>
> I need excel to look for an item #, say 1234 in cell B1, then match the
date
> in cell D1, then give me the quantity in cell C1. Now if there's two
results
> to this formula, I need it to add the quantity found in row C, since it
> problably found two same dates for that item # and two quantities. Is
this
> possible?
- Next message: Andy Brown: "Re: How to determine formula or simple value in a cell?"
- Previous message: Aladin Akyurek: "Re: Want To Count With Two Criteria"
- In reply to: JavyD: "V Look Up more than one result"
- Messages sorted by: [ date ] [ thread ]
