I want to be able to summarize how much our locations are requesting in funds, can someone help me with a formula?
Column A - Month
Column B - Date of Request
Column C - Amount
Column D - Agency (single select dropdown)
Column E - Use of funds (multi select dropdown)
Ideally I'd like to summarize column C, by column D - and if I can, by use of funds.
Example 1: Sample-Agency1 requested $x,xxx
Example 2: Sample Agency requested $x,xxx to use for Foster Care.
Help Article Resources
Check out the Formula Handbook template!