| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Obtaining & using last cell in a column in a cell formula
I have the following formula in cell C1 to count the number of cells containing figures greater than 0, zero: =COUNTIF(G4:G200,"0") However, I don't always know what will be the last cell used in column G that might be 0. What would be the fomula to count the cells with occurances 0 from G4 thru the end of column G without having to specify the very last cell in column G? (Note, not all cells from G4 to the last cell in column G will be 0) Thanks so much. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=545563 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining & using last cell in a column in a cell formula
=COUNTIF(G:G,"0")
-- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "mikeburg" wrote in message ... I have the following formula in cell C1 to count the number of cells containing figures greater than 0, zero: =COUNTIF(G4:G200,"0") However, I don't always know what will be the last cell used in column G that might be 0. What would be the fomula to count the cells with occurances 0 from G4 thru the end of column G without having to specify the very last cell in column G? (Note, not all cells from G4 to the last cell in column G will be 0) Thanks so much. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=545563 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining & using last cell in a column in a cell formula
Thanks. I thought of that, but I do not want to include the 1st three rows in column G. Any other ideas? mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=545563 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining & using last cell in a column in a cell formula
=COUNTIF(G:G,"0")-COUNTIF(G1:G3,"0")
-- HTH Bob Phillips (replace somewhere in email address with googlemail if mailing direct) "mikeburg" wrote in message ... Thanks. I thought of that, but I do not want to include the 1st three rows in column G. Any other ideas? mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=545563 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Obtaining & using last cell in a column in a cell formula
Thanks a million. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=545563 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
Linear Mode
