Welcome!

Formula to add multiple dropdown with a criteria

Example

Column 1

banana

orange

watermelon

Column 2

kid 1

kid 2

kid 3

I want to create an equation that counts, how many times kid 1 has chosen banana and orange???

Formulas

You would use something along the lines of...

=COUNTIFS([Column 2]:[Column 2], "kid 1", [Column 1]:[Column 1], AND(CONTAINS("banana", @cell), CONTAINS("orange", @cell)))

SumIF formula help
I am trying to find the right formula to use in the scenario if a cell in the row is yes, then it sums cells in the same row to create a total. threshold totalscore1 totalscore2 totalscore3 Final score yes 46 10 9 this would pull a total for the 3 total score cells in the row no 15 75 12 this cell would not total because…
Can I count cells between number thresholds if the cell also has text in it?
Hello! I'm currently creating formulas for a gift register to document the price ranges we have and how many are in each category. My categories are: £0 - £50 £50 - £100 £100 - £200 £200 + However, the formulas aren't pulling back all the data accurately because some of the cells include text too like 'less than £500' or…
RYG Formula based on Due Date and Percentage complete
I am struggling to create a formula for the RYG symbols. I would like to base it off percentage complete and due date. What I am looking for is: Red = Due date <2 days less than .90 and anything past due Yellow = Due date < 4 days less than .50 All other green