Search : in
By :

Excel Formula

Last answer on Jun 13, 2009 9:16:47 am BST Ashsih02, on Jun 12, 2009 12:52:27 pm BST 
 Report this message to moderators

Hello,
I need to calculate between two columns. Such as: If there is written (A2:A100) "aminul", then count how many times was written (B2:B100) "ok".

If there is written (A2:A100) "aminul", then count how many times was written (B2:B100) "Not ok".

If there is written (A2:A100) "ratna", then count how many times was written (B2:B100) "ok".

If there is written (A2:A100) "ratna", then count how many times was written (B2:B100) "not ok".

Thanks

Configuration: Windows XP
Firefox 1.5.0.4

Best answers for « Excel Formula » in :
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
[VBA] A function that returns the color of an active MFC Show[VBA] A function that returns the color of an active MFC This function returns the value of the active format in conditional formatting. With the function below, two values can be returned. Mode = 0: the value of Interior.ColorIndex...
Adding data from one column using another ShowAdding data from one column using another Issue Solution Note Issue I am having a real problem with an Excel formula. I have a worksheet with variable rows and a number of columns. I need to add together the values of particular...
Ask your question Reply

1

 aquarelle, on Jun 13, 2009 9:16:47 am BST

Hi,
Try with this formula :
Case 1 :
= SUMPRODUCT((A1:A14="aminul")*(B1:B14="ok"))
Case 2 :
= SUMPRODUCT((A1:A14="aminul")*(B1:B14="Not ok"))
Case 3 :
= SUMPRODUCT((A1:A14="ratna")*(B1:B14="ok"))
Case 4 :
= SUMPRODUCT((A1:A14="ratna")*(B1:B14="Not ok"))
Best regards "Pour trouver une solution à ses problèmes, il faut s'en donner la peine."

   
Reply to aquarelle
Ask your question Reply
They need your help