Looking up and filtering out data.

[VILLABILLA]

Hello dear trouble shooter,

I described my question in the attached excel file.

I didn't know what to do with it and the helpdesk from my company
didn't had a solution. Maybe one of you would know a solution...

I really hope so, it would help me a lot.

Thank you so much!

Greetz Robby

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=413549

 

[Frank Kabel]

Hi

you should use COUNTIF instead of VLOOKUP. So in your exmaple enter the
following in cell I14:
=SUMIF($C$14:$C$999,H14,$D$14:$D$999)
copy down for the other 2 rows

HTH
Frank

 

[VILLABILLA]

SUMIF is the function I was looking for and you also showed me how t
use it.

Thank you very much Frank