How can I use SUMIFS (or another function) to sum values if two rows match each other?

Options
2»

Answers

  • Kelly Mo
    Kelly Mo ✭✭
    Options

    I can't figure out what I am doing wrong now.

    image.png


    · Share on FacebookShare on Twitter
  • Kelly Mo
    Kelly Mo ✭✭
    Options

    Range 2 is from another sheet which has the same first column as this sheet and for which I want the formula to total the numbers in column 10 that match the primary column of this sheet and the Range 2 sheet.

    · Share on FacebookShare on Twitter
  • Kelly Mo
    Kelly Mo ✭✭
    Options

    This is not working, Can you please advise as to what I am doing wrong. I would like the formula to add all of the registrants from the Registration Sheet that have the same date as this sheets primary column. The registration sheet guests are column 10 of the registration sheet.

    image.png


    · 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!