Calculate Win/Loss on a quote log
I have a quote log that has a win/loss column. I want to populate a cell that takes the $ amount of the won bids, adds them up to show a total $ amount of won bids. Same for lost bids.
I also want this result to auto update if the win/loss value is changed.
Having trouble with the formula to make this work. Any help is appreciated.
Help Article Resources
Check out the Formula Handbook template!