How do I create a cross-sheet formula for a sum $ total within a date range
I'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as "1/30/19" for January 30, 2019.
For example, in the sheet in which I'm attempting to place this formula, the first column contains customer names with none repeating. The second column is "total spend in 2019", where I'm attempting to use a formula to calculate this based on the transaction summary sheet, the sheet I'm trying to reference in the formula. Any help is appreciated!
Help Article Resources
Check out the Formula Handbook template!