Hi all

I have a table that contains a schedule
one column the cells contain a items description such as "emulsion new or existing ceilings" the column next it then contains the amount required for this eg, "17.16" m2

I want to have a calculation that figures out how much painting there is to do in a schedule so it does a countif a cell contains say "emulsion" but to also add the amount required so the 17.16m2

Any help???