Sum of all months

[Veeru]

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]

Is this a homework? Sum row with that criteria.

[sassora]

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]

Thanks Sassora.....