# Adding number of times code appears in cells over a rolling period

#### dave6726

##### Board Regular
I have a formula, found elsewhere, that counts the totals of cells from current date – backwards for one year
=SUMIFS(\$L\$5:\$BDQ\$5,\$L\$3:\$BDQ\$3,"<="&F37,\$L\$3:\$BDQ\$3,">="&DATE(YEAR(F37)-1,MONTH(F37),DAY(F37)))

Data in \$L\$5:\$BDQ\$5
Dates in ,\$L\$3:\$BDQ\$3
Todays date in \$F\$37

This works perfect for numerical values in the cells. However, I have a spread sheet that has “codes” as values in the cells: Two of the codes are “SO” & “S”. I need to count (sum) these as a rolling period from current date to one year previous
Code used for COUNTIF.
=COUNTIF(L5:BDQ5,"=SO")+COUNTIF(L5:BDQ5,"=S")

Unfortunately I cannot work out how integrate the COUNTIF instead of the SUMIFS

Probably just missing something simple? Any helps would be much appreciated

### Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

#### Joe4

I think it would be helpful to see an example of your data, along with your expected results.

#### Marcelo Branco

##### MrExcel MVP
Maybe...

=SUM(COUNTIFS(\$L\$5:\$BDQ\$5,{"S","SO"},\$L\$3:\$BDQ\$3,"<="&F37,\$L\$3:\$BDQ\$3,">="&DATE(YEAR(F37)-1,MONTH(F37),DAY(F37))))

M.

#### dave6726

##### Board Regular
Maybe...

=SUM(COUNTIFS(\$L\$5:\$BDQ\$5,{"S","SO"},\$L\$3:\$BDQ\$3,"<="&F37,\$L\$3:\$BDQ\$3,">="&DATE(YEAR(F37)-1,MONTH(F37),DAY(F37))))

M.
Thank you very much Marcelo. Much appreciated.

#### Marcelo Branco

##### MrExcel MVP
You are welcome. Thanks for the feedback.

M.