Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

    scenario.pdf

  2. #2
    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •