Results 1 to 14 of 14

Count formula required

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-23-2007
    Location
    Essex, UK
    MS-Off Ver
    MS365 V2308
    Posts
    279

    Count formula required

    I currently have a formula that counts the letter 'S' when placed in a grid COUNTIF(A4:D4,"S")

    The new formula I require needs to do the same accept it needs to convert to hours. I know that if I put *12 after the bracket it will multiply the S by 12 giving a toatl but I need the numeric to change.

    ie if i put S4 in A4 and S6 in A5 i need it to recognise these numbers and give a total at the end of 10

    so formula i need is S(any number) in say A4, S(any number) in say A5, Total = (numbers added)

    Any questions if I havent explained it enough please post
    Last edited by ukphoenix; 03-28-2012 at 08:26 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1