Fin Fang Foom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 598
I have this formula that I got from this forum.
Here is the link:
http://www.mrexcel.com/board2/viewtopic.php?t=155391&postdays=0&postorder=asc&start=30
=SUMPRODUCT(1-SUBTOTAL(3,OFFSET(F3:F23,ROW(F3:F23)-ROW(F3),0,1)),--(F3:F23>0)F3:F23)
Then I'm trying to count unique subtotals values. So I came up with this, Its suppose to ignore duplicates values.
=SUMPRODUCT(1-SUBTOTAL(3,OFFSET(F3:F23,ROW(F3:F23)-ROW(F3),0,1)),--(F3:F23>0)/COUNTIF(A3:A23,A3:A23&""),F3:F23)
Its not caculating correctly.
Look at cell F26 that is the right answer.
Any Help ?
Here is the link:
http://www.mrexcel.com/board2/viewtopic.php?t=155391&postdays=0&postorder=asc&start=30
=SUMPRODUCT(1-SUBTOTAL(3,OFFSET(F3:F23,ROW(F3:F23)-ROW(F3),0,1)),--(F3:F23>0)F3:F23)
Then I'm trying to count unique subtotals values. So I came up with this, Its suppose to ignore duplicates values.
=SUMPRODUCT(1-SUBTOTAL(3,OFFSET(F3:F23,ROW(F3:F23)-ROW(F3),0,1)),--(F3:F23>0)/COUNTIF(A3:A23,A3:A23&""),F3:F23)
Its not caculating correctly.
Look at cell F26 that is the right answer.
Any Help ?