I need to subtotal based on an if
Add this formula in row 1 of an adjacent cell
=IF(A2<A1,SUMIF(A:A,A1,B:B),"")
and copy down
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Sandy" wrote in message
...
I have a list of people who are in certain groups, each person pays so
much
money and the list is added to daily. I want to know what the totals are
for
different groups.
group amt
1 50
1 25
1 75 subtot for 1
2 10
2 20 subtotal for 2
Any help
|