| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how i can count the dicontineued lines according to category wise
Dear Sir/Madam,
there is lot of categories every category have discontinued mrp lines,increged mrp lines and some of them are blank because is regular articles which are being defined as - ,+ and blank. category range is A1:A7000 and articles range also is same as category . i want to calculate the lines +,-,and blanks according to category wise. Pls help me with the formulas Best regards Santosh Gurgaon-India |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how i can count the dicontineued lines according to category wise
Hmm, perhaps:
=COUNTIF(A1:A7000,"+")+COUNTIF(A1:A7000,"-")+COUNTIF(A1:A7000,"") |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can recalculation be set to "row wise" or column wise" ? | Excel Discussion (Misc queries) | |||
| LONG CATEGORY AXIS LABELS ARE BROKEN INTO 2 LINES | Charts and Charting in Excel | |||
| Data row wise, formula column wise | Excel Discussion (Misc queries) | |||
| Delete row wise duplicates & colomun wise simultaneously excel | Excel Worksheet Functions | |||
| 255 lines in value or category X labels | Charts and Charting in Excel | |||
Linear Mode
