Want to display value in chart

[spence]

I would like to show a value if 2 type of data is chosen

Example
Due Date Date of Billing Number
05W Sept 2009 55
06S Oct 2009 47.5
07C Sept 2009 28.12

So if 05W and Sept 2009 is shown 55 will appear.

 

[Bernie Deitrick]

Spence,

With 05W in H1, and Sep 2009 in H2

=IF(SUMPRODUCT((A2:A10=H1)*(B2:B10=H2)*ROW(A2:A10))<>0,INDEX(C:C,SUMPRODUCT((A2:A10=H1)*(B2:B10=H2)*ROW(A2:A10))),"Not
Found")

You may have a problem with the dates, depending on how you entered them / formatted them. The date
values must be entered exactly the same.

HTH,
Bernie
MS Excel MVP

 

[Ashish Mathur]

=SUMPRODUCT((A3:A15=A19)*(B3:B15=B19)*(C3:C15))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com