Hi,
How do I use countif (or if you have a better suggestion please tell me) to count if:
cell1 = "a"
cell2 = ""
cell3 = ""
cell4 = "1"

I tried it out myself but I keep getting incorrect answers.. I used vba 2d array:
string = cell1 & "(" & cell2 & cell3 & cell4 & ")"
if string = "a(1)" then column next to = +1

Can you help me out?