Jump to content


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.

Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.


Excel Sum

  • Please log in to reply
2 replies to this topic

#1 ramsey76


  • Members
  • 227 posts
  • Local time:01:46 AM

Posted 31 August 2006 - 06:52 AM


I am trying to learn excel. I need help with summing up a column of data. I know how to sum numbers. I am trying to sum alpha values.

For example, a row entry can have a value of "Y" or blank. I would like to get a sum of the number of "Y" for the column.

Part 2, is similar except I not have "Y" and "N". Can I sum of the "Y" and "N" separately for each column on two separate rows.



BC AdBot (Login to Remove)


#2 tos226



  • Members
  • 1,577 posts
  • Gender:Female
  • Location:LocalHost
  • Local time:02:46 AM

Posted 03 September 2006 - 01:56 PM

use function COUNTIF(dataRange,condition) and review the required parameters in the help provided
if y and n are the only entries, then
=COUNTA(E1:E7) reports the same thing, i.e. non blank entries

Not to bee too picky, but you cannot SUM literal vaues, you can only count'm :thumbsup:

Edited by tos226, 03 September 2006 - 01:56 PM.

#3 ramsey76

  • Topic Starter

  • Members
  • 227 posts
  • Local time:01:46 AM

Posted 03 September 2006 - 05:22 PM


I also found out if you just one item ( yes vs blank) then the counta ( ) command also works.

I agree I can count the values not sum them.


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users