Forum Discussion

CC3372's avatar
CC3372
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've tried {=SUM((VLOOKUP))} - I don't even know if this is possible and why not use a SUMIF?? I know how to use a VLookup, SUMIF, SUMIFs; I feel like I"m missing something obvious or this is a trick exercise.. Maybe an excel issue..

 

Unit TypeTotal Number of Units
Per Study 
Unique Pages 

 

DriverUnits
Per Study2
Per Study2
per study2
Unique Pages50
Per Study2
per study2
per study2
per study2
Per Study2
per study2
per study2
Unique Pages50
Unique Pages50
Per Study2
excel
Formulas and Functions

3 Replies

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Feb 04, 2022

    CC3372 

    =SUMPRODUCT(--($A$8:$A$21=A3)*$B$8:$B$21)

     

    Maybe with this formula as shown in the attached file.

  • harshulz's avatar
    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

     

Resources