Countif/SumProduct

E

excelllllllll

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.
 
T

T. Valko

=SUMPRODUCT(--(G5:G15<>""),--(H5:H15<>""))

That should work.

See if this works:

=SUMPRODUCT(--(ISNUMBER(G5:G15)),--(ISNUMBER(H5:H15)))
 
M

Max

You could try using ISNUMBER, eg:
=SUMPRODUCT((ISNUMBER(A5:A15))*(ISNUMBER(B5:B15)))
Success? hit the YES below
 
E

excelllllllll

Hey I tried that and it still doesnt work. it counts all th numbers in
column A only.

I need so it only counts when numbers appear in both columns only.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SumProduct counting negative numbers 2
Variable Sumproduct Range 6
SumProduct CountIF issue 5
#value error for sumproduct using RIGHT cmd 0
How Do I Query a Named Range 2
Retrieve unique items with 2 criteria (USING SUMPRODUCT) 5
Sumproduct in matrix means 3
count unique values in one column for a set value in another col. 2

Top