5 - Automation Enthusiast
since ‎Jun 17, 2020
‎Nov 29, 2022

## User Statistics

• 11 Posts
• 0 Solutions
• 3 Kudos given

## IF function to allocate a membership fee

We are membership based organization. We currently are implementing a new membership fee structure based on how old the member is: <20= 250 € 20-25 = 500€ 26-30 = 800€ 31-34 = 1.200€ 35 = 1.200€ (older and equal to) 40 = 500 € I have all the memb...

## How to count number of times a word comes up across a different columns?

We have a weird way of keeping track how many interviews our interviewers have done. I would like to know how to count the number of times “1” comes up in each cell across all columns from Jan 2020 - August 2020. So in my simple way of formulating it...

## How to get automatic todays year into a formula

I am running a membership organization, we have “Member Since” that is a year, e.g 2014, 2018, etc. I want to calculate on a column to the right, how many years they have been member. Something in simple words like =TODAYS YEAR - “Member Since” (in...
Kudos given to