Forum Discussion

Shane Rogers's avatar
Shane Rogers
Copper Contributor
May 15, 2018

Excel Formula Help

I at best a novice with Excel so I am reaching out for help. I am trying to calculate hours based of of a letter code for an activity and need the formula to calculate a sum based of of the letter in...
Excel Help
Matt Mickle's avatar
Matt Mickle
Bronze Contributor
May 15, 2018

Shane-

 

Try something like this (See attached Excel File):

 

The formula I used can be simplified:

 

=COUNTIF(B3:AA3,LEFT($AC$2,1))

 

To

 

=COUNTIF(B3:AA3,"G")

 

  • Shane Rogers's avatar
    Shane Rogers
    Copper Contributor
    May 15, 2018

    Thank you so much!! Saved me a ton of time. 

    • Matt Mickle's avatar
      Matt Mickle
      Bronze Contributor
      May 16, 2018

      Always happy to help.  Please feel free to post back to the community if you have further issues!  This forum is a great resource!

Resources