Mikroicy
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.
A B
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
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.
A B
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