Look up and count

[Jacolene]

Hi

What is the formula for the below sample:

Supplier Nights
Kirkmans Camp 2
Ngala Safari Lodge 5
Ngorongoro Crater Lodge 10
Kirkmans Camp 1

I want now to look for name "Kirkmans Camp" in the column and then it should show me the number of nights for that supplier - 3 (nights)

[ragulduy]

use sumif.

i.e. if supplier is in column A and nights is in column B then:
=SUMIF(A:A,"Kirkmans Camp",B:B)

[Jacolene]

Thank you for the answer