Hi I am trying to sort my data in column D (for example House Payment) and either subtract the values in column E or add the values in column F to come up with the total. I am not sure of which function to use and/or how to write the formula. HELP!
This is what I tried: =SUMIFS(D2:D30000,"House Payment",$f$2:$f$30000-$e$2:$e$30000)
I'm not quite sure what you want to achieve. Sumifs can add all rows where a certain condition is met. For example "Sum all cells in F2:F30000 where D2:D30000 has the text "House Payment" in the same row.
I'm not sure what you want to do with the data in column E. Can you maybe post a screenshot and then explain the expected result in simple words?
So I attached a file for you to look at. So you can now see that in column AC I want the formula to exist. I want the formula to search for only "House Payment" in column D. Subtract all entries for House Payments in column E and Add all entries in column F for a total in column AC.