| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count values in different columns
I want a to calculate the number of values in row A for the corresponding
value in row C that is great than 1. For example in row 4 in column A I have 0.0099 but 0 in column C in row 4, therefore the result would be 0. For the whole column A the correct result should be 3. A B C 0.0134 10711 0.0160 8071 0.0170 16410 0.0099 0 0.0103 0 0.0085 8827 0.0135 0 0.0050 0.0164 0 0.0093 0 0.0105 16313 -- Chris |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count values in different columns
Chris,
Try =SUMPRODUCT((A1:A200)*(C1:C200)) Mike "Chris S." wrote: I want a to calculate the number of values in row A for the corresponding value in row C that is great than 1. For example in row 4 in column A I have 0.0099 but 0 in column C in row 4, therefore the result would be 0. For the whole column A the correct result should be 3. A B C 0.0134 10711 0.0160 8071 0.0170 16410 0.0099 0 0.0103 0 0.0085 8827 0.0135 0 0.0050 0.0164 0 0.0093 0 0.0105 16313 -- Chris |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Count values in different columns
Sorry tiy said greater than 1
=SUMPRODUCT((A1:A200)*(C1:C201)) Mike "Chris S." wrote: I want a to calculate the number of values in row A for the corresponding value in row C that is great than 1. For example in row 4 in column A I have 0.0099 but 0 in column C in row 4, therefore the result would be 0. For the whole column A the correct result should be 3. A B C 0.0134 10711 0.0160 8071 0.0170 16410 0.0099 0 0.0103 0 0.0085 8827 0.0135 0 0.0050 0.0164 0 0.0093 0 0.0105 16313 -- Chris |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count with values from multiple columns? | Excel Worksheet Functions | |||
| how do I count rows with text values in several columns. | Excel Worksheet Functions | |||
| Formula to count values in two columns | Excel Discussion (Misc queries) | |||
| I would like to Count values in two columns. | Excel Worksheet Functions | |||
| How do I count values across multiple columns? | Excel Worksheet Functions | |||
![Chris S.[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
