Forum Discussion
countif or sumproduct for this problem
i put the info in the sheet. im trying to add multiple criteria matches but im getting lost. any help is greatly appreciated! https://1drv.ms/x/s!AnFi6uGE1reki2F7ZOcOKhcx_EZj?e=JEaMwG
Is this what you were expecting?
If so, here is the formula I used in the Conditional Eval column. So if you want to calculate a sum outside the table you can simply sum the Conditional Eval column if that works.
=IF(OFFSET([@safety],2,0)<>"yes",0,COUNTIFS([player],[@player],[match],[@match],[ball in hand],"yes",[win],"yes",[inning],[@inning]))
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
rangelsammon Sorry, I made the changes in an offline copy but just transferred to your online file and saved.
- 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
rangelsammon Hello, I tried briefly last night without success. I'm sure there's a way, perhaps using the ByRow combined with a Lamda function. Do you have Excel 365? That is a prerequisite for the newer dynamic array formulas.