Forum Discussion

Redhs01's avatar
Redhs01
Copper Contributor
Jun 12, 2024

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?
  • djclements's avatar
    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

Resources