FinAnalyst
New Member
- Joined
- Dec 15, 2016
- Messages
- 3
Hi All,
I've got a range (C3:AA5000) that I want to sum. There are also two criteria rows above the range (C1:AA2) and two criteria columns left of the range (A3:B5000).
I am currently using SUMPRODUCT() and it works well, if a little slow. I've been asked to change it to a SUMIFS() as it will be quicker. To my knowledge SUMIFS() will not work for this type of summing.
Is anyone able to provide a definitive answer whether SUMIFS() will or wont work for my scenario? I've pasted an example below.
The goal is to sum to the "Account" level
Thank you in advance.
<tbody>
</tbody><colgroup><col><col><col span="4"></colgroup>
I've got a range (C3:AA5000) that I want to sum. There are also two criteria rows above the range (C1:AA2) and two criteria columns left of the range (A3:B5000).
I am currently using SUMPRODUCT() and it works well, if a little slow. I've been asked to change it to a SUMIFS() as it will be quicker. To my knowledge SUMIFS() will not work for this type of summing.
Is anyone able to provide a definitive answer whether SUMIFS() will or wont work for my scenario? I've pasted an example below.
The goal is to sum to the "Account" level
Thank you in advance.
A | B | C | D | E | F |
16/12/2015 | 16/01/2016 | 16/12/2015 | 16/01/2016 | ||
Account | Sub Account | budget | budget | actuals | actuals |
a | aa | 154 | 169 | 139 | 156 |
a | ab | 131 | 176 | 120 | 120 |
a | ac | 148 | 195 | 179 | 196 |
a | ad | 163 | 188 | 169 | 123 |
a | ae | 171 | 187 | 172 | 182 |
a | af | 111 | 172 | 126 | 161 |
a | ag | 115 | 189 | 154 | 130 |
a | ah | 149 | 133 | 172 | 119 |
b | ba | 166 | 162 | 180 | 149 |
b | bb | 110 | 171 | 132 | 154 |
b | bc | 103 | 179 | 192 | 168 |
b | bd | 124 | 108 | 116 | 191 |
b | be | 147 | 174 | 136 | 154 |
b | bf | 170 | 137 | 163 | 161 |
b | bg | 189 | 170 | 192 | 155 |
b | bh | 183 | 182 | 170 | 141 |
<tbody>
</tbody><colgroup><col><col><col span="4"></colgroup>