Thread
:
If formula
View Single Post
#
9
Posted to microsoft.public.excel.misc
Peter
external usenet poster
Posts: 349
If formula
Hi Sandy
I am after 10688.57 - this is done by
i.e. 8390.6/2 = 4154.8
5127.10/2 = 2563.55
7940.44/2 = 3970.22
Total = 10688.57
I am not looking to divide the sum by 2 - only the individual elements
(sorry if it looked that way)
"Sandy Mann" wrote:
Dividing the sum by 2 is the same as individual elements by 2 and then
summing them. What number are you looking for? 7962.36 or 10688.57? If
10688.57 how do you arrive at this number?
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Peter" wrote in message
...
Hi Sandy
thanks for looking into - sorry for confusion. £15294.72 should have been
7962.36
So the formula provided does not work - this is because it adds all 2Cs
together and then divides - I need formula to divide each cell
individually
then total
"Sandy Mann" wrote:
=SUMIF(B1:B4,"2C",A1:A4)/2
--
HTH
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
Replace @mailinator.com with @tiscali.co.uk
"Peter" wrote in message
...
Hi All,
I am looking for a formula that looks at a range, and if meets
criteria,
adds a selected range but actully divides each cell by 2 and gives sum
of
these totals
Example
Col A Col B
Row 1 8309.60 2C
Row 2 5000 2
Row 3 2488.02 2C
Row 4 5127.10 2C
If B1:b4="2c" add cells in Col A and divide by 2 then total (in this
case
would be 10688.57 NOT 15294.72)
Hope this makes sense.
Reply With Quote
Peter
View Public Profile
Find all posts by Peter