I'm having trouble figuring this out. I feel like SUMPRODUCT may be the required formula. Here's the situation:
The application is for income statements.
Across the columns is the month-end dates (1/31, 2/28, 3/31) etc... The column preceding the dates is the line items (revenue, COGS, opex...