countif or sumproduct for this problem

Question

i put the info in the sheet. im trying to add multiple criteria matches but im getting lost. any help is greatly appreciated!&nbsp;https://1drv.ms/x/s!AnFi6uGE1reki2F7ZOcOKhcx_EZj?e=JEaMwG

rangelsammon · Answer

Dexter! THANK YOU for your assistance! i really have to absorb this formula because there is plenty of functions i have never used. im going to play with it more. i think the end all requires a helper column. BUT your dedication to assist really means alot.

dexterg_iii · Answer

rangelsammon&nbsp;&nbsp;Is this what you were expecting?If so, here is the formula I used in the Conditional Eval column.&nbsp; So if you want to calculate a sum outside the table you can simply sum the Conditional Eval column if that works.&nbsp;&nbsp;&nbsp;=IF(OFFSET([@safety],2,0)&lt;&gt;"yes",0,COUNTIFS([player],[@player],[match],[@match],[ball in hand],"yes",[win],"yes",[inning],[@inning]))&nbsp;&nbsp;

rangelsammon · Answer

Thank you for the reply Dexter! can you save in the worksheet? I tried saving but i cant get it to calculate to see if it works

dexterg_iii · Answer

rangelsammon&nbsp;Sorry, I made the changes in an offline copy but just transferred to your online file and saved.&nbsp;&nbsp;

rangelsammon · Answer

Dexter, thanks for taking time to help out 🙂 i was thinking the same it might need a helper column. do you know of any way to get the count of 2 without the sum of a helper column

Forum Discussion

countif or sumproduct for this problem

8 Replies

Resources