| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text as a number
I would like to count number in column between B4 and B15 for example. But i
want count only cells B witch they has adjoining cells C with wroten text "withdraw". Can i treat text in cells as a number? I with it would be helpfull to find solution of my problem. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as a number
=SUMPRODUCT(ISNUMBER(B4:B15)*(C4:C15="withdraw"))
-- David Biddulph "Wiktor" wrote in message ... I would like to count number in column between B4 and B15 for example. But i want count only cells B witch they has adjoining cells C with wroten text "withdraw". Can i treat text in cells as a number? I with it would be helpfull to find solution of my problem. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as a number
=SUMPRODUCT(--(C4:C15="withdraw"),B4:B15)
"Wiktor" wrote in message ... I would like to count number in column between B4 and B15 for example. But i want count only cells B witch they has adjoining cells C with wroten text "withdraw". Can i treat text in cells as a number? I with it would be helpfull to find solution of my problem. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as a number
On Sep 17, 2:17 pm, "Bob Umlas" wrote:
=SUMPRODUCT(--(C4:C15="withdraw"),B4:B15) Actually, this one will add them up. If the OP wants to count, try David's formula instead. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as a number
=countif(range,criteris) that is =countif(C5:C50,"withdraw")
"Spiky" wrote: On Sep 17, 2:17 pm, "Bob Umlas" wrote: =SUMPRODUCT(--(C4:C15="withdraw"),B4:B15) Actually, this one will add them up. If the OP wants to count, try David's formula instead. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text as a number
That's if you're happy to count rows which satisfy the column C criterion,
regardless of whether there is a number in column B. The OP did say: "I would like to count number in column between B4 and B15 for example. ...." -- David Biddulph "Pritesh" wrote in message ... =countif(range,criteris) that is =countif(C5:C50,"withdraw") "Spiky" wrote: On Sep 17, 2:17 pm, "Bob Umlas" wrote: =SUMPRODUCT(--(C4:C15="withdraw"),B4:B15) Actually, this one will add them up. If the OP wants to count, try David's formula instead. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
| Counting a mixed text/number column based on text in another colum | Excel Discussion (Misc queries) | |||
| convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
| Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) | Excel Worksheet Functions | |||
| not able to convert text, or graphic number to regular number in e | Excel Worksheet Functions | |||
Linear Mode
