how to total multiple rows & columns if criteria in certain column is met

brendaoc

New member
Joined
Jul 8, 2014
Messages
9
Reaction score
0
Points
0
In my attached sheet, I would like to do the following:

For example, If Column K is 400-500-01 then sum corresponding columns & rows to give one total for that number.

I would like to sum my expenses in code 400-500-01, 400-500-02 and so forth and so on without having to manually custom sort and sum every time I add a new expense on at the bottom of the sheet. Hope that makes sense.

View attachment scenario.pdf
 

bgoree09

New member
Joined
Aug 20, 2013
Messages
179
Reaction score
0
Points
0
Good afternoon,

You can use SUMPRODUCT. I would suggest having a summary table with all of the different values in it. Your formula will look something like this:

= SUMPRODUCT ( ( $K$3:$K$1000 = //single reference here, 400-500-01 in a cell somewhere\\ ) * ( $L$3:AA$1000 ) )

and drag down.

I used '1000' and 'AA' as arbitrary figures. They can be whatever you need them to be.

Hope this helps,
 
Top