Forum Discussion
Solved
conditional formatting
Hello. So I wanted to know if there was a way to have my totals column deduct an amount if it has a conditional formatting met? Ex; I have a expense report that has business purchases and at the ...
- first off are you talking about a spreadsheet of data, a defined table, a pivot table or something else? If it is just a spreadsheet of data and you have a formula at the bottom something like =SUM(J2:J100) then probably something like this will work:
=SUM(J2:J100) - SUMIFS(J2:J100, B2:B100, "yes")
first off are you talking about a spreadsheet of data, a defined table, a pivot table or something else? If it is just a spreadsheet of data and you have a formula at the bottom something like =SUM(J2:J100) then probably something like this will work:
=SUM(J2:J100) - SUMIFS(J2:J100, B2:B100, "yes")
=SUM(J2:J100) - SUMIFS(J2:J100, B2:B100, "yes")
That worked beautifully. Thank you. It took a minute to figure out where to put the formula but after that, Amazing.