Forum Discussion

Recepcja's avatar
Recepcja
Copper Contributor
Oct 20, 2021

problem

I need a formula that will sum every "uw" from line and then multiply it by 8. It sounds simple but I have no idea how to do it.
excel
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Oct 20, 2021

Recepcja 

I assume that you want to count "uw"s.

Let's say you want to look at B2:Z2.

 

=8*COUNTIF(B2:Z2,"uw")

 

This can be filled down if required.

  • Recepcja's avatar
    Recepcja
    Copper Contributor
    Oct 20, 2021
    It's not working, shows up as a mistake
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Oct 20, 2021

      Recepcja 

      Sorry, my reply contained a typo. I have corrected it:

       

      =8*COUNTIF(B2:Z2,"uw")

      • Recepcja's avatar
        Recepcja
        Copper Contributor
        Oct 20, 2021
        It is the same as it was before and still not working

Resources