L
Legacy 410705
Guest
I have a spreadsheet set up as:
date utility units used cost
7/2/2016 gas 122 $94.86
7/12/2016 electric 98 $100.00
2/15/2017 water 99 $56.87
2/20/2017 gas 120 $122.25
4/28/2017 electric 147 $134.57
I would like to extract say all "gas" with units and organize them by date in another part of the spreadsheet so I can graph units against year. Ie. all gas sorted by year with total units. Is this possible? Is thee some other way to do this? My old "123" program had a function to do this. Thanks for any help.
date utility units used cost
7/2/2016 gas 122 $94.86
7/12/2016 electric 98 $100.00
2/15/2017 water 99 $56.87
2/20/2017 gas 120 $122.25
4/28/2017 electric 147 $134.57
I would like to extract say all "gas" with units and organize them by date in another part of the spreadsheet so I can graph units against year. Ie. all gas sorted by year with total units. Is this possible? Is thee some other way to do this? My old "123" program had a function to do this. Thanks for any help.