Dears,
last time I got great response very fast so I'm trying with other issue I faced.
I have below data:
And I need to have it calculated like this:
So I need to count how many A/B/C appear in given column. Normally I could use =COUNTIF(A2:A8,H2) and extend the formula to other columns but in database I have one column interesting me and one "empty", one column interesting me and one "empty", ect.
Thank you in advance for your support.
Basia
last time I got great response very fast so I'm trying with other issue I faced.
I have below data:
And I need to have it calculated like this:
So I need to count how many A/B/C appear in given column. Normally I could use =COUNTIF(A2:A8,H2) and extend the formula to other columns but in database I have one column interesting me and one "empty", one column interesting me and one "empty", ect.
Thank you in advance for your support.
Basia