| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count multiple condition
Hell everyone, I want to count the cells of column, the condition are 1. column Number is even. such as Column D,F,H... 2. the value if cell is greater then zer0. How to write the formula , I have no idea. Thanks -- whygh ------------------------------------------------------------------------ whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679 View this thread: http://www.excelforum.com/showthread...hreadid=493965 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count multiple condition
=SUMPRODUCT((MOD(COLUMN(D2:K20),2)=0)*(D2:K20))
adjust the range to suit -- HTH RP (remove nothere from the email address if mailing direct) "whygh" wrote in message ... Hell everyone, I want to count the cells of column, the condition are 1. column Number is even. such as Column D,F,H... 2. the value if cell is greater then zer0. How to write the formula , I have no idea. Thanks -- whygh ------------------------------------------------------------------------ whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679 View this thread: http://www.excelforum.com/showthread...hreadid=493965 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count multiple condition
Not to pick Bob but yours Sums. I think whygh was looking for a count. I know
that because you showed me how to do this... :-) -- HTH... Jim Thomlinson "Bob Phillips" wrote: =SUMPRODUCT((MOD(COLUMN(D2:K20),2)=0)*(D2:K20)) adjust the range to suit -- HTH RP (remove nothere from the email address if mailing direct) "whygh" wrote in message ... Hell everyone, I want to count the cells of column, the condition are 1. column Number is even. such as Column D,F,H... 2. the value if cell is greater then zer0. How to write the formula , I have no idea. Thanks -- whygh ------------------------------------------------------------------------ whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679 View this thread: http://www.excelforum.com/showthread...hreadid=493965 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count multiple condition
Thank you guys! I tried "=SUMPRODUCT((MOD(COLUMN(2:2), 2)=0)*(2:20))" it works. AS to "=SUMPRODUCT((MOD(COLUMN(D2:K20),2)=0)*(D2:K20 ))" , It is the sum of the even columns and values greater than zero. I also use it . Vivian -- whygh ------------------------------------------------------------------------ whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679 View this thread: http://www.excelforum.com/showthread...hreadid=493965 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count multiple condition
This is for row 2...
=SUMPRODUCT((MOD(COLUMN(2:2), 2)=0)*(2:20)) -- HTH... Jim Thomlinson "whygh" wrote: Hell everyone, I want to count the cells of column, the condition are 1. column Number is even. such as Column D,F,H... 2. the value if cell is greater then zer0. How to write the formula , I have no idea. Thanks -- whygh ------------------------------------------------------------------------ whygh's Profile: http://www.excelforum.com/member.php...o&userid=29679 View this thread: http://www.excelforum.com/showthread...hreadid=493965 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count until condition is met and then retain final count | Excel Discussion (Misc queries) | |||
| lookup with multiple condition, but one condition to satisfy is en | Excel Worksheet Functions | |||
| helps with count under multiple condition | Excel Discussion (Misc queries) | |||
| What formula/fn would I use to count multiple condition records? | Excel Worksheet Functions | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
Hybrid Mode
