RogerKMiller

asked on

# Is there an Excel 2003 version of COUNTIFS

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<>"")>0))

this counts every 21 columns if there is a non-blank

try:

=SUMPRODUCT(--((MOD(COLUMN

this counts every 21 columns if there is a non-blank

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

thanks