Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count If
I've got values in cells on different pages in a workbook. Let's say that they are all in A1 across 25 different sheets. I want to count the number of times the value in each cell is "Unacceptable" ? Thanks in advance -- JohnHill ------------------------------------------------------------------------ JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171 View this thread: http://www.excelforum.com/showthread...hreadid=549338 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count If
Hi John
I would use a helper cell on each sheet say X1 with a formula of =--(A1="Unacceptable) Then the answer is =SUM(Sheet1:Sheet25!X1) -- Regards Roger Govier "JohnHill" wrote in message ... I've got values in cells on different pages in a workbook. Let's say that they are all in A1 across 25 different sheets. I want to count the number of times the value in each cell is "Unacceptable" ? Thanks in advance -- JohnHill ------------------------------------------------------------------------ JohnHill's Profile: http://www.excelforum.com/member.php...o&userid=25171 View this thread: http://www.excelforum.com/showthread...hreadid=549338 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtotals by count | Excel Discussion (Misc queries) | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions |