Hi Steve,

Please change your title (read forum rule #1)

I'am MCAS myself and it's a "button" exam. SUMIF is about the most complicated function. For the layman MCAS sound very impressive and it wouldn't do bad on a CV. Better than telling you read a few books!

Better would be to have Mr Excel before or after your name Job references would be a good start. Try to become a Forum Guru, that might help.

Good luck.