+ Reply to Thread
Results 1 to 2 of 2

count cell range with a certain letter

  1. #1
    Registered User
    Join Date
    01-19-2011
    Location
    Perth WA
    MS-Off Ver
    Excel 2003
    Posts
    1

    count cell range with a certain letter

    Please help. Try as I might, I cannot find a simple formula which will sum all the cells in a row which are marked "A". The next cell has to tally all the cells marked "B".

    I thought this would work but it didn't:

    =SUM(B2:B40="A")

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: count cell range with a certain letter

    Perhaps:

    Please Login or Register  to view this content.

+ Reply to Thread

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