Thread: Count cells based on whether another cell is blank or not
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
  
Posts: 9,221
Default Count cells based on whether another cell is blank or not
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.


Reply With QuoteReply With Quote