Microsoft Office Questions? Ask a IT Expert for Support ASAP
Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question
what are you looking to do with a formula?
Hi Andrew. Thanks for responding so quickly.
We rent out properties in France and would like to set up a formula to track the numbers of guests from each country.
I have been trying to do this with a COUNTIF formula.
So for example, =COUNTIF(H3:H54,"American")
This works okay but does not help with numbers
So, I have the nationality in row H and in row G a number
are you trying to count where the specific text occurs
can you provide a sample sheet
if you click the paperclip icon at the top of the chat
it says image
but you can post an excel file the same way
after clicking paperclip
so are you looking for a total of the numbers
so if there are 3 american values
you would want the result to be 12
is this correct
i think i need to see the actual sheet to make this work for you
also will give me a better understanding
if I can see the exact setup
can you try the paperclip option
Okay - no problem.
to post the actual sheet
Yeah, sure. Just spotted it!
Did you get that ok?
give me a min to open
It's not the full spreadshett I'm afraid as there's a lot of sensitive financial info in a lot of the cells - sorry!
just as long as I get an idea
i can give you the correct formulas
gonna take me a minute to open anway
still firing up excel
so where is the problem ocuring
I see cells B59
seam to have those formulas
those values look correct to me.
unless you were looking for different values
In think I got the COUNTIF formula right, but I wasn't sure how to multiply.
what are you multiplying
what values x what values
So, in the example of C3, we had 5 Americans.
Can I multiply x5 and get it to come up below?
try this formula
then copy and paste that to
B60 - B66
or however many you need
lemme know how it works out for you
I get 51 Americans in total which is spot on - great!
please don't forget to rate
bonus also appreciated
Would that formula work with all the cells and nationalities?
just copy and paste the formula
down to b60
Excellent - many thanks for your help!
or however many rows you need