Greetings,
My goal here is to add up grand totals at the top of the spreadsheet for total dollar amount. I already got the miles figured out....
I am wondering how to sum up the amounts below containing $ only. Is this possible? Or would it be possible to add up all of the values in column 1 excluding cells that have the word "miles" in column 2.
Any assistance is appreciated!
Cheers
My goal here is to add up grand totals at the top of the spreadsheet for total dollar amount. I already got the miles figured out....
I am wondering how to sum up the amounts below containing $ only. Is this possible? Or would it be possible to add up all of the values in column 1 excluding cells that have the word "miles" in column 2.
Any assistance is appreciated!
Cheers
amount | category | 200 | total miles | |
50 | miles | total $ from amount column 1??????? formula??? | total $ | |
50 | miles | |||
50 | miles | |||
$ 10.00 | meal | |||
$ 20.00 | supplies | |||
$ 30.00 | car | |||
$ 100.00 | travel | |||
50 | miles |