beanaschnitzel
New Member
- Joined
- Nov 21, 2017
- Messages
- 1
Hello,
Thank you for any help you can provide.
Table 1
I am wanting to sum up the cost (USD) (Column I) for each market (Column D) and place that cost by date into the second Table by market in Column AA. I have been unable to figure this out. I have been able to group it but it adds all of them together and not by date. So for 11/7/17 Fort Worth I would want it to say $0.00 since nothing was spent as you can see from Table 1. El Paso would have $249.87 and so forth. Let me know if any additional information is needed. Thank you for your assistance.
https://docs.google.com/spreadsheets/d/1UWnLavTugg-Qy_Nd04v6NVF_sNdierjnhVbK2DWQ-Rk/edit?usp=sharing
Thank you for any help you can provide.
Table 1
I am wanting to sum up the cost (USD) (Column I) for each market (Column D) and place that cost by date into the second Table by market in Column AA. I have been unable to figure this out. I have been able to group it but it adds all of them together and not by date. So for 11/7/17 Fort Worth I would want it to say $0.00 since nothing was spent as you can see from Table 1. El Paso would have $249.87 and so forth. Let me know if any additional information is needed. Thank you for your assistance.
https://docs.google.com/spreadsheets/d/1UWnLavTugg-Qy_Nd04v6NVF_sNdierjnhVbK2DWQ-Rk/edit?usp=sharing