View Full Version : Converting countif to frequency

06-28-2019, 02:59 AM
Hy everyone,

I have a bit of a problem with my workook. To make some equations work, I would need to count specific values based on the value of the cell next to it. Since there is a lot of data countif doesnt work so good. to speed up the process, I would like to use frequncy instead.

1 nausea treatment A
2 headache treatment B
3 nausea treatment A
4 nausea treatment C

Now what I need is a function (frequency) that would count the occuraces of nausea when treament A was used.

To use countif: =COUNTIFS(A1:A1000,"nausea",B1:B1000,"treatment A")

To use frequency = ??

Thank you

06-28-2019, 06:32 AM
My first thoughts on this would be to use a pivot table; they're fast even with lots of data.
Supply a worksheet/book with this sort of data in to help us. Also how you'd like to see the results.

07-05-2019, 05:11 AM
Sorry for the late response. I will actually scrub the whole thing and try a different approach. Got a few ideas that might work, but need a lot of time to do it.