Formula Issue

Debbie McKay GLP GTP CCTE

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.

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

Debbie McKay GLP GTP CCTE

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

Debbie McKay GLP GTP CCTE

Great!  Thank you Craig!

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