Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to refer to current column in a formula?
Say I've named the range of rows 10 through 50 as "Rowset." Then I want to put a formula in C8 that returns how many cells in C10:C50 are equal to "0". I can use COUNTIF(C:C Rowset,"0"), which works fine. But what if I also want to do the same thing in D8, E8, etc. Do I have to explicity say COUNTIF(D:D Rowset,"0") COUNTIF(E:E Rowset,"0") etc.? Or is there some way I can refer to the current column without naming it? I realize I can define the first formula as above and then copy and paste to get corresponding formulas in the other cooumns. I just wondered if there was one formula I could define so that it would work the same in any column. Thanks in advance for any help! Jim Guinness Eastern Massachusettts, USA -- jmg092548 ------------------------------------------------------------------------ jmg092548's Profile: http://www.excelforum.com/member.php...o&userid=26119 View this thread: http://www.excelforum.com/showthread...hreadid=394467 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert rows based on specific value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
I need a formula to sum column b if column a is between two dates | Excel Discussion (Misc queries) | |||
I need a formula to sum column b if column a is between two dates | Excel Discussion (Misc queries) | |||
how to enter a formula using column() function for a range | Excel Worksheet Functions |