Hi
try
=SUMPRODUCT(--(A1:A10<""),--(B1:B10<""))
"dave" wrote:
Hi,
I am try to add up the number of entries in a column, only if there is
another entry on the same row in another specified column.
ie
A B
1 x i
2 t
3 r
4 t
The total for this would be 1.
Many Thanks in advance
|