Hi,
ok i have 2 columns....



Column A Column B

32 -

54 20

45 -

65 76

75 75



I need to add the number of times Column A and Column B both have values.
SO in this case its 3 times.

I'm not sure if i use count if or sumproduct and how. I tried:
=SUMPRODUCT(--(G5:G15<""),--(H5:H15<"")) but its giving the wrong value.
value.