Need assistance please

[Broga1981]

I am trying to total in column C the amount of expired training my staff have. When i try the formulas it is saying Im using to many arguments. The cells are not together so The formula I tried is

=countif(E10,G10,I10,K10,M10,O10,Q10,S10,U10,W10,Y10,AA10""<"&TODAY())

Is there a better way of doing this?

 

[Peter_SSs]

Try

=SUMPRODUCT(--(MOD(COLUMN(E10:AA10)-COLUMN(E10),2)=0),--(E10:AA10<>""),--(E10:AA10<TODAY()))

 

[Broga1981]

Try

=SUMPRODUCT(--(MOD(COLUMN(E10:AA10)-COLUMN(E10),2)=0),--(E10:AA10<>""),--(E10:AA10<TODAY()))

Amazing. Thank you so much for this, I'd never have got there :D

 

[Peter_SSs]

Amazing. Thank you so much for this, I'd never have got there :D

You're welcome.