| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNTA counting formulas as well.
F17/(AVERAGE(C17,B17))*(12/(COUNTA(B5:B16)))
in B5:B16, I have this formula.. =IF(SUM(Start:End!B5)=0,"",SUM(Start:End!B5)) Now the problem is...the COUNTA function in the first formula above is counting all the cells in the range B5:B16. I want it to NOT count the cells which are blank as a result of the formula (The second formula above). I want it to count only if the result is =0. Ideas? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTA counting formulas as well.
Maybe something like this:
=F17/(AVERAGE(C17,B17))*(12/(SUMPRODUCT(--(B5:B16<"")))) HTH, Paul -- "Gaurav" wrote in message ... F17/(AVERAGE(C17,B17))*(12/(COUNTA(B5:B16))) in B5:B16, I have this formula.. =IF(SUM(Start:End!B5)=0,"",SUM(Start:End!B5)) Now the problem is...the COUNTA function in the first formula above is counting all the cells in the range B5:B16. I want it to NOT count the cells which are blank as a result of the formula (The second formula above). I want it to count only if the result is =0. Ideas? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNTA counting formulas as well.
Great!! That worked.
Thanks. "PCLIVE" wrote in message ... Maybe something like this: =F17/(AVERAGE(C17,B17))*(12/(SUMPRODUCT(--(B5:B16<"")))) HTH, Paul -- "Gaurav" wrote in message ... F17/(AVERAGE(C17,B17))*(12/(COUNTA(B5:B16))) in B5:B16, I have this formula.. =IF(SUM(Start:End!B5)=0,"",SUM(Start:End!B5)) Now the problem is...the COUNTA function in the first formula above is counting all the cells in the range B5:B16. I want it to NOT count the cells which are blank as a result of the formula (The second formula above). I want it to count only if the result is =0. Ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| the countA function is counting everything even empty cells | Excel Worksheet Functions | |||
| counta function can any one explain the example counting 2 | Excel Discussion (Misc queries) | |||
| Sumproducts, Counta Lookup Ref Formulas | Excel Discussion (Misc queries) | |||
| Errors in COUNT, COUNTA, COUNTIF when counting merged cells | Excel Worksheet Functions | |||
| COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions | |||
![Gaurav[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
