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...
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.

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