I find your discription a bit had to understand buy one way with

30's in Column H, 60's in Column I & 90's in Column J

Count of 30's:
=SUMPRODUCT((H1:H5=30)*(I1:I5<60)*(J1:J5<90))

Count of 60's:
=SUMPRODUCT((I1:I5=60)*(J1:J5<90))

Countif 90's
=COUNTIF(J1:J5,90)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Maggie" wrote in message
oups.com...
I have three columns one that is 30, one that is 60 and one that is
90. I am counting the times my day lands on 30, 60, 90 but if it
happens within the same account, then I am counting just the larger of
the three. So if I have a 30 days and a 60 days for an account, I
would pick the 60 days. Is there a formula in order for excel to
figure out which one to pick?