Forum Discussion

RHughes11569's avatar
RHughes11569
Copper Contributor
Nov 04, 2020
Solved

Vlookup and Sum Help

Can someone help me out with a forumla?   I'm trying to enter an item # on the Lookup sheet of the attached sample and have the YTD Forecast cell in B2 return the sum of the YTD Totals from the Pla...
excel
Formulas and Functions
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Nov 04, 2020

    RHughes11569 Try this in B2 on "Lookup"

    =SUMIFS(Planning!D2:D46,Planning!A2:A46,A2,Planning!C2:C46,"Forecast")

     

  • RHughes11569's avatar
    RHughes11569
    Copper Contributor
    Nov 04, 2020

    SergeiBaklan Not that I know a ton about Pivot Tables yet either, but I'm trying to make this as plug & play as possible because some of the people that will be using it know very little about Excel.  I appreciate you helping out though.  I'm definitely learning as I go, so pivot tables are on my list.

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 05, 2020

      RHughes11569 

      The minus of PivotTable is that user shall to refresh it after updating the data, formulas do recalculation automatically. At the same time that's quite powerful tool and this option better to keep in mind. Everything depends on concrete situation.

Resources