theonlyhamish
New Member
- Joined
- Aug 13, 2021
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Hi all, Just a beginner and have tried various iterations of the countifs and sum functions to achieve this calculation.
I am trying to generate a count of 3 columns with mixed criteria so that i can feed the data simply into a fixed report page (i was using a pivot table but the boss doesnt like the way that 'looks')
Ive attached an image with made up data and what i thought was the right formula Columns A,C,D have different values and i need to count at the end of that row if the row meets all 3 of the variables. There is likely a more simplistic way of achieving this than i have found!
I am trying to generate a count of 3 columns with mixed criteria so that i can feed the data simply into a fixed report page (i was using a pivot table but the boss doesnt like the way that 'looks')
Ive attached an image with made up data and what i thought was the right formula Columns A,C,D have different values and i need to count at the end of that row if the row meets all 3 of the variables. There is likely a more simplistic way of achieving this than i have found!
