| Home |
| Search |
| Today's Posts |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need to count a row with something in it
A100
1B00 10C0 D100 = 400 I need to add the rows the problem that I am running into is that it does not recognize the number because of the alpha included in the number I hope this explains it a little better "T. Valko" wrote: It's not clear what you want. Can you provide a more detailed explanation? -- Biff Microsoft Excel MVP "Elvira" wrote in message ... I have a simmilar problem. I need to count rows with combinations of letters and alpha i.e. 45A111 + 45A222 should equal 90333. I need the formula to exclude the numeric factor. Please advice "T. Valko" wrote: You're welcome. Thanks for the feedback! -- Biff Microsoft Excel MVP "Rick" wrote in message ... T. Valko..... You are the best..... this stuff is sooooo simple if you know the basic rules ..... oh yea just like life Thanks again!!! "T. Valko" wrote: Maybe this: =COUNTA(D61:J61) That will return the count of cells in the range that are not empty. -- Biff Microsoft Excel MVP "Rick" wrote in message ... I have been following this strem but have not seen something that I need .... I need to count a row (e.g., d61:j61) with anything in it - either a number or word .... can one of you please help me??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
| how do i count text and display it as text plus the # times it hap | New Users to Excel | |||
| how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
| Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
