Forum Discussion
Creating a formula that checks a variable number of columns
Hi, have what I assume to be a relatively simple query. I'm trying to create a formula for a spreadsheet that I have which I need to add columns periodically to (one for each week) to log attenda...
For Att. Total:
=COUNTIF($A2:INDEX(2:2,MATCH("Att. Total",$1:$1)-1),"Y")
For Att. Rate:
=D2/(MATCH("Att. Total",$1:$1)-1)
Excel will automatically adjust D2 when you insert more columns.
HansVogelaar Thanks, worked perfectly.