Forum Discussion
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...
RHughes11569 Try this in B2 on "Lookup"
=SUMIFS(Planning!D2:D46,Planning!A2:A46,A2,Planning!C2:C46,"Forecast")
RHughes11569 Try this in B2 on "Lookup"
=SUMIFS(Planning!D2:D46,Planning!A2:A46,A2,Planning!C2:C46,"Forecast")
Riny_van_Eekelen That works for me! I was able to copy your formula into my sheet and then massage it a little to get it to work for my specific worksheet. Thanks!