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

2 replies to this topic

### #1 ramsey76

ramsey76

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

Posted 31 August 2006 - 06:52 AM

Hello

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.

Thanks

Tom

### #2 tos226

tos226

BleepIN--BleepOUT

• Members
• 1,577 posts
• OFFLINE
•
• 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
examples
=COUNTIF(E1:E77,"y")
=COUNTIF(A1:B55,"y")
=COUNTIF(E1:E77,"y")+COUNTIF(E1:E77,"n")
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

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

### #3 ramsey76

ramsey76
• Topic Starter

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

Posted 03 September 2006 - 05:22 PM

Thanks

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.

T

#### 0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users