Lookup row value to sum array of values in another column

Pierre Mostert
Pierre Mostert ✭✭✭✭
in Formulas and Functions

Good day

Can someone please assist to modify the formula to search for value in column ID and match the corresponding value in column ID Lookup. Once matched it should sum all the values in column HP with corresponding value in ID

Screenshot 2024-10-10 at 3.05.39 PM.png

Thanks!

Pierre

· Share on FacebookShare on Twitter

Answers

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi @Pierre Mostert,

    Try this formula:

    =SUMIFS(HP:HP, ID:ID, [ID Lookup]@row)

    I notice that your screenshot also uses the month. Do you need this formula to also use the month?

    Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com)

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Report PDF generator that supports grouped and summarized reports
    • Automatic sorting, sorting with filters, saving sort settings
    • Hiding and unhiding columns, and spell checking

    · Share on FacebookShare on Twitter
  • Pierre Mostert
    Pierre Mostert ✭✭✭✭

    Good day

    Yes if you can please include the month it will be helpful?

    Thanks a mil!

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!