Counting
I have a spreadsheet which every other column has 1's,A's,M's or is blank . I
would like to be able to tell how many blanks or 1's or M's or A's are in the colomn, and would like to also know how many in the total for all of the every other column hope this makes sense. Alan |
Counting
=COUNTIF($G$1:$G$20,"=1") =COUNTIF($G$1:$G$20,"=A") =COUNTBLANK($G$1:$G$20) "and would like to also know how many in the total for all of the every other column" Haven't a clue what you want for this part. -- babycody ------------------------------------------------------------------------ babycody's Profile: http://www.excelforum.com/member.php...o&userid=13120 View this thread: http://www.excelforum.com/showthread...hreadid=555396 |
Counting
Pls post in ONE group only
-- Don Guillett SalesAid Software "fomula problems" wrote in message ... I have a spreadsheet which every other column has 1's,A's,M's or is blank . I would like to be able to tell how many blanks or 1's or M's or A's are in the colomn, and would like to also know how many in the total for all of the every other column hope this makes sense. Alan |
Counting
Did not realise that I was in more than one group.
"Don Guillett" wrote: Pls post in ONE group only -- Don Guillett SalesAid Software "fomula problems" wrote in message ... I have a spreadsheet which every other column has 1's,A's,M's or is blank . I would like to be able to tell how many blanks or 1's or M's or A's are in the colomn, and would like to also know how many in the total for all of the every other column hope this makes sense. Alan |
All times are GMT +1. The time now is 06:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com