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.

Photo

Excel Sum


  • Please log in to reply
2 replies to this topic

#1 ramsey76

ramsey76

  • Members
  • 227 posts
  • OFFLINE
  •  
  • Local time:08:31 PM

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

BC AdBot (Login to Remove)

 


#2 tos226

tos226

    BleepIN--BleepOUT


  • Members
  • 1,574 posts
  • OFFLINE
  •  
  • Gender:Female
  • Location:LocalHost
  • Local time:09:31 PM

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 :thumbsup:

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


#3 ramsey76

ramsey76
  • Topic Starter

  • Members
  • 227 posts
  • OFFLINE
  •  
  • Local time:08:31 PM

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