<div>
Can you be more specific as to what the formula should do? SUMPRODUCT is the nearest thing to COUNTIFS in 2003 but it sounds as though COUNTA or COUNTBLANK might be more relevant here.
</div>


<div>
Assuming your range is B1:BA1<br />
<br />
try:<br />
<br />
=SUMPRODUCT(--((MOD(COLUMN<wbr />(B1:BA1)-C<wbr />OLUMN(B1),<wbr />21)=0)*(B1<wbr />:BA1&lt;&gt;&quot;&quot;)&gt;<wbr />0))<br />
<br />
this counts every 21 columns if there is a non-blank
</div>


<div>
<div class="content wysiwyg-content">
I'm trying to figure out how to write an if statement that will include counting whether or not 7 different individual cells are blank but the cells, not ranges, are spaced every 21 columns. &nbsp;Looks like I could do it with =COUNTIFS but not a feature of Excel 2003.
</div>
</div>


I'm trying to figure out how to write an if statement that will include counting whether or not 7 different individual cells are blank but the cells, not ranges, are spaced every 21 columns.  Looks like I could do it with =COUNTIFS but not a feature of Excel 2003.

Can you be more specific as to what the formula should do? SUMPRODUCT is the nearest thing to COUNTIFS in 2003 but it sounds as though COUNTA or COUNTBLANK might be more relevant here.

Assuming your range is B1:BA1

try:

=SUMPRODUCT(--((MOD(COLUMN(B1:BA1)-COLUMN(B1),21)=0)*(B1:BA1&lt;&gt;&quot;&quot;)&gt;0))

this counts every 21 columns if there is a non-blank

Is there an Excel 2003 version of COUNTIFS

I&#39;m trying to figure out how to write an if statement that will include counting whether or not 7 different individual cells are blank but the cells, not ranges, are spaced every 21 columns.  Looks like I could do it with =COUNTIFS but not a feature of Excel 2003.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.