Hi Guys,

I am creating a fee register spreadsheet for a construction job.

The first column will read: ie/
HYDRAULIC ENGINEER
Abc company
123 company
456 company

ELECTRICAL ENGINEER
ghj company
lkp company
typ company

The third column will have the fee amount.

In the second column I want an IF function where if 'yes' is selected from a drop down list it will sum only these fee amounts(I have already created the drop down list).

Thankyou in advance,
Danny