Hello all,

after spending the afternoon on this one, I resigned and thought I'd bring this to the board.

I have a data input sheet and a summary sheet which uses countifs to report on month end numbers. I have everything figured out except my final column. I need to know how many applications have either an applicant or the joint applicant aged 60+.

The client's age and the joint client's age are recoreded in two separate columns.

Can I use a combination of a countifs and an OR formula? or is the SUMPRODUCT function what I'm after and how?

I have uploaded a simplified sample. Thanks in advance!!
Countifs OR example.xls