I am trying to automatically create a table that calculates per diems, depending on the country. I have a list of all the countries in column A, with the daily rate in column C. I've created a drop-down using the list of countries from column A for people to select the country from. I'd like the next cell in the table to automatically fill in the value in C associated with this country. I've tried playing around with various sumif(s), but I'm stuck.
Any pointers?
well your sumif needs to be this...
=SUMIF(A13:A210, B2, C13:C210)
but if I'm understanding this correctly you could also use a vlookup like this...
=VLOOKUP(B2,$A$13:$C$210,3,FALSE)
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Try this
Formula:
Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Went with the first one and it works perfectly. Merci!
you're welcome and THANK YOU for the rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks