| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
![whygh[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
