Indirect function help

[smatchymo]

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?

Please Login or Register  to view this content.

Thanks in advance!

[smatchymo]

Disregard, not sure why I thought this required an indirect function...

Please Login or Register  to view this content.