Forum Discussion
Need help with a formula in excel
Greetings, I need help writing a formula. Attached is a screen shot of my data in excel. What I am trying to accomplish is to have excel return the number of times a specific code occurs under ea...
Hi
Although I cannot clearly see the column headings in your screenshot but assuming that your first condition is in Column A (Starting from A2 to A500
and your second criteria range is in Column F starting from F2 to F500'
Then
You want to count based upon 2 conditions :
Options for Condition 1 are set in Column J starting from J6
Options for condition 2 is in Cell K5
Then in Cell K6 I will create a SUMPRODUCT function as follows:
=SUMPRODUCT(($A$2:$A$500=$K$5)*($F$2:$F$500=$J$6))
Hope that helps
Nabil Mourad