Column A Column B a traded b online c online a online how do i make a code that counts lets say how many “a” is either traded or online I tried =COUNTIFS(A:A, “a”, B:B, “Traded”, B:B, “Online”) and expected 2 but i got 0 instead google-sheets New contributor Clarice is a new contributor to […]

Wk 01 Wk 02 Wk 03 Wk 04 Wk 05 Wk 06 Wk 07 Wk 08 Wk 09 Amersham Town N/A 2 2.5 3.5 3.75 3.78 3.7 3.82 3.82 Bagshot N/A 0.5 0.75 0.67 1 1.13 1 1 0.91 Bedfont FC N/A 3 2.5 3 2.8 2.83 2.57 2.75 3 Berks County N/A 2 3.33 […]

I have a table of fixtures with scores input.

Demontration of what the result should look like
I need a formula in Google Sheets that iterates each input from input range, the look-up results for every single input will be stacked into a column per the order that the inputs appear in the range (top to down). Hope you could help. Thank you.

I am trying to set up a system on Google Sheets, where checking a checkbox will write out a list, for example:

I am trying to set up a system on Google Sheets, where checking a checkbox will write out a list, for example:

I am trying to set up a system on Google Sheets, where checking a checkbox will write out a list, for example:

I am trying to take away the price from the total if the box is ticked.

enter image description here As you can see in the image above, I want to be able to clear certain cells whenever the values in either of the dropdown changes in GOOGLE SHEETS

good-day, my friend and I are going on holiday and we always sort of plan every day what we are going to do and we have always managed somehow, but now we are going to Japan and as we are someone from Eastern Europe it is quite expensive for us, so we want to make the most of every day we can. We each have lots of ideas where to go, what to experience etc. and I’m trying to make it easier for us with a spreadsheet where we enter: Area, Experience Name, Station, Area Map, Note, Links, that would be the first page.
Then there would be sheets with each day, where I’d like to have a rolling down menu (or whatever would be just as functional) where we would select an area, then another rolling down menu where there would just be experiences from that area, and once that experience is selected, the rest of the cells would fill themselves out according to the data we entered in the first sheet. I know it’s probably a lot, but unfortunately my skills aren’t up to it and what I’ve done is functional, but it’s actually not much better than filling in the data manually, which is very frustrating and I wish it was more functional, it would help us a lot, even in planning our next trip,