| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How i count coulm by conditon
Hi All
Can any one help me in the following, If I have the excel file A b C 22 23 26 65 01 -32 32 - 53 10 12 23 22 How I do the following 1- Count the data in A with the condution IF CX 0 so the amount will be 22+32+12 2- Count the data in C with the condution IF CX <0 so the amount will be -32 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How i count coulm by conditon
I Do it by
SUMIF "M.K" wrote: Hi All Can any one help me in the following, If I have the excel file A b C 22 23 26 65 01 -32 32 - 53 10 12 23 22 How I do the following 1- Count the data in A with the condution IF CX 0 so the amount will be 22+32+12 2- Count the data in C with the condution IF CX <0 so the amount will be -32 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How i count coulm by conditon
HI M.K.
TRY WITH THE FOLLOWING FOR YOUR FIRST QUESTION = SUMIF(C:C,"0",A:A) FOR YOUR SECOND QUESTION = SUMIF(C:C,"<0",A:A) CLICK BELOW YES, IF IT WORKS FOR U "M.K" wrote: Hi All Can any one help me in the following, If I have the excel file A b C 22 23 26 65 01 -32 32 - 53 10 12 23 22 How I do the following 1- Count the data in A with the condution IF CX 0 so the amount will be 22+32+12 2- Count the data in C with the condution IF CX <0 so the amount will be -32 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| key coulm | Excel Discussion (Misc queries) | |||
| key coulm | Excel Discussion (Misc queries) | |||
| copying conditon formats with $ | Excel Worksheet Functions | |||
| Get data with certain conditon | Excel Discussion (Misc queries) | |||
| How to determine the number from given conditon? | Excel Discussion (Misc queries) | |||
![M.K[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
