That would be either A or B not A and B
To me it sounds as if the OP wants A and B
"Basically I want to count the amount of times that there is data in
col a and col b along the same row"
^^^^^^^^^^^^^
--
Regards,
Peo Sjoblom
"Max" wrote in message
...
One way
Something like this, in say C1:
=SUMPRODUCT(--((A1:A10<"")+(B1:B10<"")0))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:15,900 Files:354 Subscribers:53
xdemechanik
---
"luvnrocs" wrote in message
...
I have a spreadsheet with data in 2 columns and I want to be able to
figure out how many times there is data in col A and Col B of each
row. If either cell is empty I don't want it counted.
Basically I want to count the amount of times that there is data in
col a and col b along the same row.
Thanks.