| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNTIF
i want to know how to calculate the following things
A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- .. .. .. .. RSL 20GP 40GP 40HC ---------------------------------------------- .. .. .. .. JV 20GP 40GP 40HC ---------------------------------------------- .. .. .. .. .. if understand kindly help me out. regards Malik Nadeem |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
DEAR Don Guillett
THANKS FOR YOUR GUIDANCE YES YOU ARE RIGHT THERE WAS ONLY 2 ALMAR SHOWING THAT WAS TYPO MISTAKE FROM MY SIDE HOW EVER IT CAN SOLVE MY PROBLEM BUT I WANT TO KNOW IS THERE ANY RESULT WE CAN GET WITH THE HELP OF =COUNTIF FORMULA OR FUNCTION? IF YES KINDLY ADVISE THE SAME. THANKS IN ADVANCE FOR YOUR GREAT SUPPORT AN HELP. REGARDS MALIK NADEEM waiting for your reply. ======================== "Malik Nadeem" wrote: i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- . . . . RSL 20GP 40GP 40HC ---------------------------------------------- . . . . JV 20GP 40GP 40HC ---------------------------------------------- . . . . . if understand kindly help me out. regards Malik Nadeem |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
Please get your caps lock key repaired so that you can stop SHOUTING.
-- David Biddulph "Malik Nadeem" wrote in message ... DEAR Don Guillett THANKS FOR YOUR GUIDANCE YES YOU ARE RIGHT THERE WAS ONLY 2 ALMAR SHOWING THAT WAS TYPO MISTAKE FROM MY SIDE HOW EVER IT CAN SOLVE MY PROBLEM BUT I WANT TO KNOW IS THERE ANY RESULT WE CAN GET WITH THE HELP OF =COUNTIF FORMULA OR FUNCTION? IF YES KINDLY ADVISE THE SAME. THANKS IN ADVANCE FOR YOUR GREAT SUPPORT AN HELP. REGARDS MALIK NADEEM waiting for your reply. ======================== "Malik Nadeem" wrote: i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- . . . . RSL 20GP 40GP 40HC ---------------------------------------------- . . . . JV 20GP 40GP 40HC ---------------------------------------------- . . . . . if understand kindly help me out. regards Malik Nadeem |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
Dear David,
sorry for this. is there any way from i can transfer my excel file in which i have lot of data it will be much better for you people to understand below help of don is good and helpful for me but when i m applying same condition on my main file it is not working some time result FALS some some 0 or - what sould i do can you please help me out to fix this problem? you great support in this regards will be highly appreciated. regards Malik Nadeem "David Biddulph" wrote: Please get your caps lock key repaired so that you can stop SHOUTING. -- David Biddulph "Malik Nadeem" wrote in message ... DEAR Don Guillett THANKS FOR YOUR GUIDANCE YES YOU ARE RIGHT THERE WAS ONLY 2 ALMAR SHOWING THAT WAS TYPO MISTAKE FROM MY SIDE HOW EVER IT CAN SOLVE MY PROBLEM BUT I WANT TO KNOW IS THERE ANY RESULT WE CAN GET WITH THE HELP OF =COUNTIF FORMULA OR FUNCTION? IF YES KINDLY ADVISE THE SAME. THANKS IN ADVANCE FOR YOUR GREAT SUPPORT AN HELP. REGARDS MALIK NADEEM waiting for your reply. ======================== "Malik Nadeem" wrote: i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- . . . . RSL 20GP 40GP 40HC ---------------------------------------------- . . . . JV 20GP 40GP 40HC ---------------------------------------------- . . . . . if understand kindly help me out. regards Malik Nadeem |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
file is uploaded on
http://www.mediafire.com/?sharekey=b...db6fb9a8902bda kindly check and revert "Malik Nadeem" wrote: Dear David, sorry for this. is there any way from i can transfer my excel file in which i have lot of data it will be much better for you people to understand below help of don is good and helpful for me but when i m applying same condition on my main file it is not working some time result FALS some some 0 or - what sould i do can you please help me out to fix this problem? you great support in this regards will be highly appreciated. regards Malik Nadeem "David Biddulph" wrote: Please get your caps lock key repaired so that you can stop SHOUTING. -- David Biddulph "Malik Nadeem" wrote in message ... DEAR Don Guillett THANKS FOR YOUR GUIDANCE YES YOU ARE RIGHT THERE WAS ONLY 2 ALMAR SHOWING THAT WAS TYPO MISTAKE FROM MY SIDE HOW EVER IT CAN SOLVE MY PROBLEM BUT I WANT TO KNOW IS THERE ANY RESULT WE CAN GET WITH THE HELP OF =COUNTIF FORMULA OR FUNCTION? IF YES KINDLY ADVISE THE SAME. THANKS IN ADVANCE FOR YOUR GREAT SUPPORT AN HELP. REGARDS MALIK NADEEM waiting for your reply. ======================== "Malik Nadeem" wrote: i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- . . . . RSL 20GP 40GP 40HC ---------------------------------------------- . . . . JV 20GP 40GP 40HC ---------------------------------------------- . . . . . if understand kindly help me out. regards Malik Nadeem |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
Dear Don
further on below msg can i sent you the main excel file beacuse i am unable to do that through this formula can you please tell me how to i gave you the file you can see that problem which i m facing. waiting for your reply. "Malik Nadeem" wrote: DEAR Don Guillett THANKS FOR YOUR GUIDANCE YES YOU ARE RIGHT THERE WAS ONLY 2 ALMAR SHOWING THAT WAS TYPO MISTAKE FROM MY SIDE HOW EVER IT CAN SOLVE MY PROBLEM BUT I WANT TO KNOW IS THERE ANY RESULT WE CAN GET WITH THE HELP OF =COUNTIF FORMULA OR FUNCTION? IF YES KINDLY ADVISE THE SAME. THANKS IN ADVANCE FOR YOUR GREAT SUPPORT AN HELP. REGARDS MALIK NADEEM waiting for your reply. ======================== "Malik Nadeem" wrote: i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- . . . . RSL 20GP 40GP 40HC ---------------------------------------------- . . . . JV 20GP 40GP 40HC ---------------------------------------------- . . . . . if understand kindly help me out. regards Malik Nadeem |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
|
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
COUNTIF
=SUMPRODUCT((RSL!$E$3:$E$848=$B$10)*(RSL!$C$3:$C$8 48=B$11)*(RSL!$S$3:$S$848=$A12))
defined names to make self adjusting =SUMPRODUCT((RSLcolE=$B$10)*(RSLcolC=B$11)*(RSLcol S=$A20)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett" wrote in message ... Send to my address below along with a clear explanation and before/after examples -- Don Guillett Microsoft MVP Excel SalesAid Software "Malik Nadeem" wrote in message ... Dear Don further on below msg can i sent you the main excel file beacuse i am unable to do that through this formula can you please tell me how to i gave you the file you can see that problem which i m facing. waiting for your reply. "Malik Nadeem" wrote: DEAR Don Guillett THANKS FOR YOUR GUIDANCE YES YOU ARE RIGHT THERE WAS ONLY 2 ALMAR SHOWING THAT WAS TYPO MISTAKE FROM MY SIDE HOW EVER IT CAN SOLVE MY PROBLEM BUT I WANT TO KNOW IS THERE ANY RESULT WE CAN GET WITH THE HELP OF =COUNTIF FORMULA OR FUNCTION? IF YES KINDLY ADVISE THE SAME. THANKS IN ADVANCE FOR YOUR GREAT SUPPORT AN HELP. REGARDS MALIK NADEEM waiting for your reply. ======================== "Malik Nadeem" wrote: i want to know how to calculate the following things A B C D 12345 20GP ALMAR MTY 67892 40GP JV ILD 11111 40HC RSL O/H 22222 40GP FLORENCE SOLD 12345 40GP ALMAR ILD 67892 20GP JV O/H 11111 40HC RSL MTY 22222 40HC FLORENCE ILD NEED THE RESULT IN FOLLOWING CONDITION ALMAR 20GP 40GP 40HC ---------------------------------------------- MTY 1 1 0 ILD 1 0 0 O/H 0 0 0 FLORENCE. 20GP 40GP 40HC ---------------------------------------------- . . . . RSL 20GP 40GP 40HC ---------------------------------------------- . . . . JV 20GP 40GP 40HC ---------------------------------------------- . . . . . if understand kindly help me out. regards Malik Nadeem |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| COUNTIF.... | Excel Worksheet Functions | |||
| How do I use a countif function according to two other countif fu. | Excel Worksheet Functions | |||
| edit this =COUNTIF(A1:F16,"*1-2*")+COUNTIF(A1:F16,"*2-1*") | Excel Discussion (Misc queries) | |||
| COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
| COUNTIF in one colum then COUNTIF in another...??? | Excel Worksheet Functions | |||
Hybrid Mode
