Excel SUMIF fomula?

[mermar]

I am creating a attendance calendar for employees, I would like it to add the time I input for accumulation for the month. I would like to sum the numbers in certain cells depending on the Data Validation code in the cell above.
=SUM(C14:P14,C17:P17,C20:P20,C23:P23,C26:P26)*IF(C13:P13,C16:P16,C19:P19,C22:P22,C25:P25,contains "A")

 

[AlphaFrog]

Try something like this...

=SUMIF(C13:P25,"*a*",C14:P26)

This assumes C15:P15, C18:P18, C21:P21, C24:P24, C21:P21 don't contain a

 

[mermar]

Thanks, works great!

 

[mermar]

Is there a way to copy/paste this formula without it changing the cells to consecutive numbers?