I'm trying to generate an equation to calculate the total value of costs in
one column, if there status value in another column is equal to 100 (or it
could be a string value of "Confirmed" - the value 100 is arbitary).

So it's Consolidate the Values in Column A if the corresponding Value in
Column B=100 and provide a SUM total in Column C.

Not sure if this would be a Conditional Formula but hope someone can help.

regards

adrian