|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 17th, 2008, 07:32 PM
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
September 17th, 2008, 08:10 PM
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
September 17th, 2008, 08:17 PM
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
September 17th, 2008, 08:29 PM
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
September 18th, 2008, 10:17 AM
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
September 18th, 2008, 04:04 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
