Mar 06 2021 02:22 AM
Hi all,
I recently started using excel for my studies. I have been using countifs formulas but now i am stuck.
I was calculating the amount of people in a certain age range by using =COUNTIFS(VolvoOceanAllData[Year of birth];">1936";VolvoOceanAllData[Year of birth];"<1951").
Every time i entered the formula, excel couldnt work with it, kept marking the quotation marks.
I asked my teachers advise, who entered the formula in her document, where it worked. She sent her document to me, and i copied the formula from her document (WHICH WAS EXACTLY THE SAME) to mine. I inserted the formula and it worked, but when I manually copy the formula and write it myself, it does not work.
I have no clue what the problem is, it almost seems like my hands typing the formula are not suited for excel :))))
Mar 06 2021 03:26 AM
SolutionMar 08 2021 06:52 AM
Mar 06 2021 03:26 AM
Solution