I have a table with 14 columns (see attached image):

First column (column A) is the name of the expense

Column 2-13 (column B-M) is the months January to December (with January = 1, February = 2… December = 12)

Column 14 (column N) is a grouping of the expenses.

In the table in each of the month columns (column B-M), the expense for that month is entered.

E.g., in the first column one expense could be called “LinkedIn ads” and another expense could be called “facebook ads” and then they would both be called “Marketing expense” in column N.

Now, I would like to be able to dynamically SUM all expenses that match a combination of a specific month (columns B-M) and a specific group (column N).

For example, let say I would like to sum all the expenses for March (column D) that are grouped as “Marketing expenses” column (N)

I tried some combination of IF formulas with SUM and SUMIF but cannot seem to make it work. enter image description here

1 Answer 1


Use filter(), like this:

=sum( iferror( filter( filter(B2:M, B1:M1 = month("1 March")), N2:N = "Marketing costs" ) ) )

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.