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 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 |
Try variations on this formula
=SUMPRODUCT(--(ISNUMBER(FIND("radio",A1:A100)))) if you want case dependency, or =SUMPRODUCT(--(ISNUMBER(SEARCH("radio",A1:A100)))) if not -- HTH RP (remove nothere from the email address if mailing direct) "the6thlee" wrote in message ... 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 |
All times are GMT +1. The time now is 05:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com