I already know how to count the number of appearance of a condition for one column by using this formula after it has been filtered.
(SUMPRODUCT(SUBTOTAL(3,OFFSET(Signatures!B46:B1040,ROW(Signatures!B46:B1040)-ROW(Signatures!B46),,1)),--(Signatures!B46:B1040=3)))
So now I want to know how to count if two condition from two column has happen. for example, how many times, B46:B1040 = condition 1 and C46:B1040 is = condition 2 has happend together.
another example to make it more clear:
Imagine I have 10 companies and I have all the demographic data from these 10 companies, so now I want to filter into one of these company and I want excel automatically count the number of the female who are from the department x? is there any formula for that?
I would greatly appreciate any help.
(SUMPRODUCT(SUBTOTAL(3,OFFSET(Signatures!B46:B1040,ROW(Signatures!B46:B1040)-ROW(Signatures!B46),,1)),--(Signatures!B46:B1040=3)))
So now I want to know how to count if two condition from two column has happen. for example, how many times, B46:B1040 = condition 1 and C46:B1040 is = condition 2 has happend together.
another example to make it more clear:
Imagine I have 10 companies and I have all the demographic data from these 10 companies, so now I want to filter into one of these company and I want excel automatically count the number of the female who are from the department x? is there any formula for that?
I would greatly appreciate any help.
