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?
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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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" <[email protected]> wrote in message
news:[email protected]...
>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?
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?
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?
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?
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks