Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple count function
Hi, I want to do a very simple calculation in excel I have a number of columns, that can be populated with a 0 or non-0 value. I want a summary field that says number of non-zero columns? Any help would be great. Joe -- berminator ------------------------------------------------------------------------ berminator's Profile: http://www.excelforum.com/member.php...o&userid=24833 View this thread: http://www.excelforum.com/showthread...hreadid=383851 |
#2
|
|||
|
|||
Try using =COUNTIF(G4:M4,"<0") where g to m are the column you are lookin for zero values in. Ruth -- Ruthki ------------------------------------------------------------------------ Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503 View this thread: http://www.excelforum.com/showthread...hreadid=383851 |
#3
|
|||
|
|||
That was excellent Ruth, Thanks! Now, I have another one! Of the range of cells, say 20 columns, I want to sum the best 14 from the 20, in order of highest rank. So say I have 20 columns , with values of 1-20. I want the sum of the top 14, which would be 20+19+18+…etc. Any easy way to do this? Joe -- berminator ------------------------------------------------------------------------ berminator's Profile: http://www.excelforum.com/member.php...o&userid=24833 View this thread: http://www.excelforum.com/showthread...hreadid=383851 |
#4
|
|||
|
|||
=SUMPRODUCT(LARGE(A1:T1,ROW(INDIRECT("1:14"))))
-- HTH Bob Phillips "berminator" wrote in message ... That was excellent Ruth, Thanks! Now, I have another one! Of the range of cells, say 20 columns, I want to sum the best 14 from the 20, in order of highest rank. So say I have 20 columns , with values of 1-20. I want the sum of the top 14, which would be 20+19+18+.etc. Any easy way to do this? Joe -- berminator ------------------------------------------------------------------------ berminator's Profile: http://www.excelforum.com/member.php...o&userid=24833 View this thread: http://www.excelforum.com/showthread...hreadid=383851 |
#5
|
|||
|
|||
Thanks again, worked a treat! -- berminator ------------------------------------------------------------------------ berminator's Profile: http://www.excelforum.com/member.php...o&userid=24833 View this thread: http://www.excelforum.com/showthread...hreadid=383851 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel should have a function to count sheets | Excel Worksheet Functions | |||
How do I add the count function to the toolbar? | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Simple, Monday morning brain function | Excel Worksheet Functions | |||
count function | Excel Worksheet Functions |