Hi Group!
I've got a question on using SUMIFS to pull data horizontally with multiple criteria. I have a table of data in which the column headers are month end dates, and each row corresponds to a unique account with monthly data amounts.
Example
<tbody>
</tbody>
I want to write a SUMIFS statement which will sum columns B to E where column A equals a certain account, and where row 1 (with the month end dates) is less than or equal to the current month end on another sheet. So, if the month end date were 3/31 and we wanted the year to date total for account 101, the result would be 6.
I have tried to SUMIFS(B:E, B1:E1, <= 3/31, A1:A5, "101") I'm getting a value error which I cant seem to get around.
Any help would be greatly appreciated.
Thank you.
I've got a question on using SUMIFS to pull data horizontally with multiple criteria. I have a table of data in which the column headers are month end dates, and each row corresponds to a unique account with monthly data amounts.
Example
A | B | C | D | E | |
1 | 1/31 | 2/28 | 3/31 | 4/30 | |
2 | 103 | 2 | 3 | 1 | 4 |
3 | 101 | 3 | 2 | 1 | 1 |
4 | 102 | 4 | 2 | 0 | 1 |
5 | 104 | 0 | 0 | 2 | 0 |
<tbody>
</tbody>
I want to write a SUMIFS statement which will sum columns B to E where column A equals a certain account, and where row 1 (with the month end dates) is less than or equal to the current month end on another sheet. So, if the month end date were 3/31 and we wanted the year to date total for account 101, the result would be 6.
I have tried to SUMIFS(B:E, B1:E1, <= 3/31, A1:A5, "101") I'm getting a value error which I cant seem to get around.
Any help would be greatly appreciated.
Thank you.