Forum Discussion
Redhs01
Jun 12, 2024Copper Contributor
Need a formula
Please help I need a formula for the following PM =8 and N =8 this needs to be calculated then taken off the value of 70 How do i do this?
- Jun 12, 2024
Redhs01 There's a lot left to the imagination here, but one possibility could be:
=value - SUM(COUNTIF(range, {"PM","N"})) * 8
For example, if the value 70 is in cell A1 and the range to evaluate is B1:N1, the formula would be:
=A1 - SUM(COUNTIF(B1:N1, {"PM","N"})) * 8
djclements
Jun 12, 2024Bronze Contributor
Redhs01 There's a lot left to the imagination here, but one possibility could be:
=value - SUM(COUNTIF(range, {"PM","N"})) * 8
For example, if the value 70 is in cell A1 and the range to evaluate is B1:N1, the formula would be:
=A1 - SUM(COUNTIF(B1:N1, {"PM","N"})) * 8
Redhs01
Jun 12, 2024Copper Contributor
Thank you but it doesn't add up correctly, it has the total as 70 when it should be 30 as there are 5 PM or N which being 8 each = 40. Sorry what am i doing wrong??
- Redhs01Jun 12, 2024Copper ContributorAll good I was missing a ".....thank you for your help much appreciated
- djclementsJun 12, 2024Bronze Contributor
Redhs01 You're welcome. I'm glad you were able to work it out. 🙂
- Redhs01Jun 12, 2024Copper ContributorAlso if I take out the =A1- the total comes out at 0.....that isn't correct i would have thought it would come out at 40??