=COUNTIFS to SUM FREQUENCY MATCH

**brybry1212** · 08-09-2017, 11:10 PM

Hello, working with a large sheet and need to copy down
=COUNTIFS(N:N,N2,H:H,H2)
,however, excel bombs out on me. In reading through various forums, using a formula like
=SUM(--(FREQUENCY(IF(c1,IF(c2,MATCH(vals,vals,0))),ROW(vals)-ROW(vals.1st)+1)>0))
may take less computing.
1) is this the correct formula to replace my countifs ?
2) if so, how do I fill in the SUM FREQUENCY MATCH formula? I've tried numerous scenarios and get errors.
Thank you so much for the help.

**FDibbins** · 08-09-2017, 11:37 PM

Hi, welcome to the forum

your countifs should work, and will definitely be more efficient than the array formula using FREQ

what does "excel bombs out on me" mean?
what exactly are you trying to do?
upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**brybry1212** · 08-10-2017, 08:22 AM

Sorry, "bombs out" meaning, the screen turns white and excel stops working. I have 300K rows. The COUNTIFS function does work with small amount of data, but not with a very large sheet, I then copy and paste the formula into values that's when the sheet freezes.