# counting Multiple answers in 1 cell + column

1. ## counting Multiple answers in 1 cell + column

how do u count multiple values in the one cell and down the entire column?
i want to count all magazines answers in column A1. i would like to get the
answer (4) for magazines, (4) for tv, and (3) for radio. and it does not
seperate cells. i tried the formula = COUNTIF(range, "value") but the
formula doesnt not count the values if there are more than one value in the
cell... see example below

A1 A2
2 magazines
4 tv
6 magazines, tv

2. ## Re: counting Multiple answers in 1 cell + column

Try variations on this formula

if you want case dependency, or

if not

--

HTH

RP
(remove nothere from the email address if mailing direct)

"the6thlee" <the6thlee@discussions.microsoft.com> wrote in message
news:3453B9DC-DD5A-448C-B5C5-3586AE9AB0E2@microsoft.com...
> how do u count multiple values in the one cell and down the entire column?
> i want to count all magazines answers in column A1. i would like to get

the
> answer (4) for magazines, (4) for tv, and (3) for radio. and it does not
> matter if the counting of the values, magazine,tv,radio, is answered in
> seperate cells. i tried the formula = COUNTIF(range, "value") but the
> formula doesnt not count the values if there are more than one value in

the
> cell... see example below
>
> A1 A2
> 2 magazines
> 4 tv
> 6 magazines, tv
>

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1