Excel Formula - can't find one that works

[stilgar]

I'm making a speadsheet for all my quotes so i can keep a record of which one's i've quoted, won, and lost.

in one column i have the value of the quote and in another i have the status. (eg, WON, LOST, Quoted) i then have the total of all the quotes value at the bottom of the sheet.

now i want so add a cell that only add's the value of the quotes that are won and another that add's the value of the one's that are lost.

so column "F" has the value of the quotes and column "G" has the status.

If column "G" has "WON" in it then i want it to add the value from column "F" hence adding all the won quotes together.

Any idea's?

 

[VoG]

Try like this

=SUMIF(G1:G100,"WON",F1:F100)

 

[Trevor G]

Welcome to the Forum,

You need to look at SUMIF.

 

[stilgar]

Thanks for that guys! worked a treat!