is there a way to add single digits within a single cell?
i need to create a spread sheet to use for tick marks through out the day. I
need the ticks added up and then totaled by catagory. How do I add the values with in a single cell? |
You have not explained this very well!
Suppose you have column A for counting cats and B for counting dogs. Every time you see a cat you put an X in the next empty cell of column A. In C1 use =COUNTIF(A:A."X") to count the cats. Note the X's could be x's - not case sensitive. Anywhere near the problem? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "ceci" wrote in message ... i need to create a spread sheet to use for tick marks through out the day. I need the ticks added up and then totaled by catagory. How do I add the values with in a single cell? |
Sounds like you are talking about the SUM(...) function, as far as I can
tell. Use as follows: =SUM(summation_range) -- Regards, Dave "ceci" wrote: i need to create a spread sheet to use for tick marks through out the day. I need the ticks added up and then totaled by catagory. How do I add the values with in a single cell? |
ceci Wrote: i need to create a spread sheet to use for tick marks through out the day. I need the ticks added up and then totaled by catagory. How do I add the values with in a single cell? Hi ceci try the countif function -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=396967 |
All times are GMT +1. The time now is 08:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com