title: Count column if it contains a filled cell in Excel
body: <p>This is a simple question, but I cannot find the answer anywhere.</p>
  
  <p>So, let's say I have range <code>A1:D20</code>, with at least one value in columns A and C. The number of columns with at least one filled cell is therefore 2.</p>
  
  <p>How do I get a formula to count the number of columns within a range that contain at least one value? I would also like to count columns with criteria, but that's of secondary importance at the moment.</p>
  
  <p>I have a large range of at least 35 columns, so a shorter expression would be very helpful.</p>