Try this:

=SUMIF(B:B,100,A:A)

Hope this helps.

Pete

"StrontiumDog67" wrote in message
...
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