COUNTIFS OR...multiple countifs without duplication in the numbers

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

Hi HooligaD,

Try this formula in 'East Summary'!I4 = COUNTIFS(East!A:A,A4,East!Q:Q,">=60")+COUNTIFS(East!A:A,A4,East!Q:Q,"<60",East!S:S,">=60")

The OR statement is adding two criterias... (if ClientAge>=60) + (if ClientAge<60 and JointAge>=60)

Hope that makes sense...

Let me know otherwise...

Dennis

Thanks Melvinrobb and Dennis.

Worked perfectly!