matching with two condition

[naveen4pundir]

Hi,
i want to match a column with 2 condition.

Ist is Number and 2nd is date but where i want to match my date is in header. excel sheet attach.

[CheshireCat]

Try this:

=SUMPRODUCT(--($A$2:$A$14=$G2),--($C$2:$C$14=H$1),$B$2:$B$14)

[Vidar]

I might have misundestood the question but this
formula look up the count corresponding to the date.
Paste this formula in H2 and copy to the right.
=INDEX($B$2:$C$14,MATCH(H$1,$C$2:$C$14,0),1)

Vidar

[naveen4pundir]

thanx a lot ...it working..

---------- Post added at 11:39 PM ---------- Previous post was at 11:37 PM ----------

Try this:

=SUMPRODUCT(--($A$2:$A$14=$G2),--($C$2:$C$14=H$1),$B$2:$B$14)

Thanx a lot ..it's working..

[day92]

Or this...

=SUMIFS($B$2:$B$14,$A$2:$A$14,$G2,$C$2:$C$14,H$1)