H
help me i have an excel problem
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
1 magazines, tv, radio
2 magazines
3 tv, radio
4 tv
5 magazines, radio
6 magazines, tv
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
1 magazines, tv, radio
2 magazines
3 tv, radio
4 tv
5 magazines, radio
6 magazines, tv