Forum Discussion

Maddy1010's avatar
Maddy1010
Brass Contributor
Sep 24, 2025
Solved

vlookup, then sumif

Hello.  I am not sure if what I am asking is possible.  But here goes:  It is possible to incorporate a vlookup or match in my formula, whereby it first looks up what is column B, then as a result of a match, it sums up column C, then the rest of my formula.  In my current formula, it still feels "manual", in that I have to select individual cells in column C - and this is too time consuming as I have thousands of rows.  Here is my current formula:  (C2/SUM(C$2,C$6,C$10))*(SUMIFS($J$2:$J$17,$H$2:$H$17,$B2))

excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Sep 24, 2025

    In E2 try this:

    =IFERROR(
    C2 / SUMIFS($C$2:$C$13, $B$2:$B$13, B2) *
        (SUMIFS($M$2:$M$17, $K$2:$K$17, $B2)),
    0
)

    and copy down.

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Sep 24, 2025

    In E2 try this:

    =IFERROR(
    C2 / SUMIFS($C$2:$C$13, $B$2:$B$13, B2) *
        (SUMIFS($M$2:$M$17, $K$2:$K$17, $B2)),
    0
)

    and copy down.

Resources