Forum Discussion

Copper Contributor

Feb 03, 2022

=SUM(VLOOKUP) - Thoughts? Needed ASAP :( HELP!

Hello, I've been asked to complete the following Using the VLOOKUP formula, pull the total number of units from the "Data" tab into the cells... Well, I'm trying =SUM((VLOOKUP)) with no luck, I'...

excel

Formulas and Functions

harshulz

Iron Contributor

Feb 04, 2022

CC3372

i have tried sum(vlookup) function, but didnt get through it.

however we can solven it using sumif

and with sumifs as shown below