Hi all,
I have a list of dated transactions which have been categorized. I'd like to sum these transactions if the date is between a certain range and is in a particular category. Rather than have a separate formula for each category, I'd like to use one formula with an indirect reference. I tried this formula, but I can't auto-fill other cells because of the quotes around A2. I have all of the categories listed in the second row, so I'd be auto-filling across, B2, C2, etc. The date ranges are obviously in AW and AX. Where should I be including my quotes so it looks for text, but still is able to auto-fill across?
Thanks in advance!
Bookmarks