Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
sum if
2 views
Skip to first unread message
Richard
Oct 27, 2007, 10:23:37 AM10/27/07
to
I want to add the values from cell A1 to A6. However, if any values is
greater 8, I must minus .5, then add them. If they not greater 8, then just
add them to the total. How do I do this in an sum if statement?
greater 8, I must minus .5, then add them. If they not greater 8, then just
add them to the total. How do I do this in an sum if statement?
www.exciter.gr: Custom Excel Applications!
Oct 28, 2007, 4:29:45 PM10/28/07
to
i dont know if this suits you, it is not sumif but it works
=SUM(A1:A6)-COUNTIF(A1:A6;">8")*0,5
First part is total sum and the second counts the values >8 and
multiplies their number * 0.5. Then is part1-part2
Best
0 new messages