Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Issue

Debbie McKay GLP GTP CCTE
Debbie McKay GLP GTP CCTE ✭
edited 12/09/19 in Archived 2016 Posts

I am trying to search one column and if it returns "travel agency name" then to add all data in "# of RPS".  But I keep coming up with an error.

 

Any suggestions?

 

Thank you.

· Share on FacebookShare on Twitter

Comments

  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Screen shot or more detail may be needed to help.

     

    Is "travel agency name" what you are looking for or is that a generic example?

    Ie, are you searching for "Bob's Travel Agency" and then for every row that it appears, you want to add up the data in the [# of RPS] column?

     

    Try SUMIF

     

    Craig

    · Share on FacebookShare on Twitter
  • Debbie McKay GLP GTP CCTE
    Debbie McKay GLP GTP CCTE ✭
    edited 11/11/16

    The column is Travel Agency.  I want to search that column and find all XYZ Agency in that column.  Then take all of those that were found and add up the "Estimated RFPs" so that I have a total of all of XYZ's RFPs.  

     

    deb

    · Share on FacebookShare on Twitter
  • Debbie McKay GLP GTP CCTE
    Debbie McKay GLP GTP CCTE ✭

    Great!  Thank you Craig!

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭

    Then you definitely want SUMIF

     

    This needs to go into another column besides [Travel Agency]

     

    =SUMIF([Travel Agency]:[Travel Agency],"XYZ Agency",[Estimated RFPs]:[Estimated RFPs])

     

    Here's another convenience if you want to get more flexibility -- "XYZ Agency" can be a cell reference, so you could have a few rows to have which ones you want to see.

    Those can even be in the [Travel Agency] column, since [Estimate RFPs] for that row should be blank.

     

    Hope that helps.


    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories