M
M
I am looking for a formula that will allow me to, for a row that meets a
given criteria, add all the columns together that meet another criteria.
For example, how can I add the value of the "A" columns in the "Alpha" row.
A B A B
Alpha 10 400 60 100
Beta 20 200 50 200
Delta 30 250 70 150
Of course my real data set contains hundreds of rows and dozens of columns,
with more row and columns being added every month.
given criteria, add all the columns together that meet another criteria.
For example, how can I add the value of the "A" columns in the "Alpha" row.
A B A B
Alpha 10 400 60 100
Beta 20 200 50 200
Delta 30 250 70 150
Of course my real data set contains hundreds of rows and dozens of columns,
with more row and columns being added every month.