Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure if count is the correct formula... Excel 2002
I have a formula that I use for every job I complete that is inserted into
the "Time" column, and above this I have "Jobs" basically count the number of Jobs I have completed for the week =COUNTA(F6:F47), however since I have added the new formula to the "Time" cells it is counting all of them, how do I resolve this issue |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure if count is the correct formula... Excel 2002
What is in column F? Are they formulas in which some return blank? When
using COUNTA, even if a cell appears blank but has a formula in it, it will get counted. If that is the case, then you might consider using SUMPRODUCT. =SUMPRODUCT(--(F6:F47<"")) If this is not what you're doing, post an example of your data and formulas. HTH, Paul -- "Carlo" wrote in message ... I have a formula that I use for every job I complete that is inserted into the "Time" column, and above this I have "Jobs" basically count the number of Jobs I have completed for the week =COUNTA(F6:F47), however since I have added the new formula to the "Time" cells it is counting all of them, how do I resolve this issue |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure if count is the correct formula... Excel 2002
Paul thank you for your quick response, its not exactly what I am doing, so I
have "Jobs" counting a different column to give me the same results "PCLIVE" wrote: What is in column F? Are they formulas in which some return blank? When using COUNTA, even if a cell appears blank but has a formula in it, it will get counted. If that is the case, then you might consider using SUMPRODUCT. =SUMPRODUCT(--(F6:F47<"")) If this is not what you're doing, post an example of your data and formulas. HTH, Paul -- "Carlo" wrote in message ... I have a formula that I use for every job I complete that is inserted into the "Time" column, and above this I have "Jobs" basically count the number of Jobs I have completed for the week =COUNTA(F6:F47), however since I have added the new formula to the "Time" cells it is counting all of them, how do I resolve this issue |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not sure if count is the correct formula... Excel 2002
Thank you Paul. Your sting seems to work OK, however when I use it on my
SmartPhone it does work (Error), however my old string does work, maybe its just to long "PCLIVE" wrote: What is in column F? Are they formulas in which some return blank? When using COUNTA, even if a cell appears blank but has a formula in it, it will get counted. If that is the case, then you might consider using SUMPRODUCT. =SUMPRODUCT(--(F6:F47<"")) If this is not what you're doing, post an example of your data and formulas. HTH, Paul -- "Carlo" wrote in message ... I have a formula that I use for every job I complete that is inserted into the "Time" column, and above this I have "Jobs" basically count the number of Jobs I have completed for the week =COUNTA(F6:F47), however since I have added the new formula to the "Time" cells it is counting all of them, how do I resolve this issue |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My excel formula is correct, however, my total is off by .01. | Excel Worksheet Functions | |||
Excel 2002: How to eliminate space within a cell and count items? | Excel Discussion (Misc queries) | |||
How do I correct error using the =IF(AND(formula in excel? | Excel Worksheet Functions | |||
How do I correct error using the =IF(AND(formula in excel? | Excel Worksheet Functions | |||
Can I expand the column count in excel 2002. Or limited to 256? | Excel Discussion (Misc queries) |