View Full Version : [SOLVED:] Sum of all months
Veeru
03-20-2018, 09:52 PM
Hi,
I am looking for a formula, which gives me sumof all months basis of cetera we have
Attaching the file for better reference.
Thanks
Tom Jones
03-20-2018, 11:36 PM
Is this a homework? Sum row with that criteria.
sassora
03-21-2018, 12:43 AM
I initially tried SUMIFS, since that generally solves this type of problem (sum given conditions). I don't think it liked having column array inputs for the criteria and a rectangular array for the sum values.
Instead you can use a Ctrl-Shift-Enter formula (array formula), for example
=SUM(IF(A2:A8=A16,IF(B2:B8=B16,C2:N8)))
Whereas in usual formulas you just press Enter to evaluate them, here you press Ctrl-Shift-Enter simultaneously. This will give the formula a set of curly brackets, i.e. {= formula }.
This give the correct sum for the first part, it is fairly straightforward to apply this to the second part, which should help with getting to how to use this type of structure.
Veeru
03-21-2018, 01:11 AM
Thanks Sassora.....
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.