View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
luvnrocs luvnrocs is offline
external usenet poster
 
Posts: 5
Default Count cells based on whether another cell is blank or not

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.