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.
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
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
Great! Thank you Craig!
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.
