Hi Maggie,

That does not work this is what my columns look like:
A B C
30 60 90
1 1 1

Since the account was 30 days,60 days, and 90 days, I only want the 90
days to count instead of counting each column. Is there a way to do a
formula for that?


I assume that the "30" etc are column headers and since you are using 1's
as an indicator just use that in the formula:

For the Totals of each category use:

30
=SUMPRODUCT((A1:A10=1)*(B1:B10<1)*(C1:C10<1))

60
=SUMPRODUCT((B1:B10=1)*(C1:C10<1))

90
=COUNTIF(C2:C10,1)
or simply
=COUNT(C2:C10)

This assumes that the 1's are real numbers and not text

If you want to count at the end of each row then use:

=IF(COUNT(A2:C2)=0,"",IF(C2,"90",IF(B2,"60","30 ")))

Replacing the "90" etc with whatever you want.

--
HTH

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


with @tiscali.co.uk