formulas for excel

  steves100 18:56 30 Oct 05
Locked

Formulas for excel
I’m not sure this is the best forum for my question!
But here goes. I’m have problems with creating a formula to return a numeric code for a letter i.e. say Holiday =H = 8hours so if there is say five H’s in one row then the total would return a value of 40 . Has anyone got any ideas please.
Stevie.

  Forum Editor 19:20 30 Oct 05

instead of the Helproom - I'll move your thread there now, and you'll soon have your answer.

  VoG II 19:24 30 Oct 05

=COUNTIF(A1:J1,"H")*8

  steves100 19:33 30 Oct 05

Thanks VoG i got a bit bogged down there it was the 'IF' Part i totaly forgot about thanks again.
Stevie.

  Forum Editor 19:57 30 Oct 05

4 minutes - not bad, eh?

  stalion 19:58 30 Oct 05

bit slow for VoG™ lol

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Why ecommerce hasn't taken off on social media

New MacBook Pro 2016 review | MacBook Pro with Touch Bar review: Apple's expensive and powerful…