Well I'm glad you got it straightened out in the end.

Pete

On Mar 11, 5:06*pm, Peter wrote:
DOH, Doh Doh Doh Doh..

No wonder I am getting confused - it does help if I have the correct figures
etc.

Sandy, Pete(uk) and David Biddulph - thank you for trying to help someone
who is obviously short sighted and needs to go home for a beer!

Of course - formula that I originally tried and the same formula that you
provided gives me the correct answer



"Sandy Mann" wrote:
2488.02/2 = 3970.00 ?????

--
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
...
mmm, me thinks me is losing the plot.

Lets try again.

8309.60/2 = 4154.80
5127.10/2 = 2563.55
2488.02/2 = 3970.00

sum * * * * = 10688.57

Need to get this when criteria is met

"Sandy Mann" wrote:

Just seen your reply to Pete, where did the 7940.44 come from? you had
2488.02 in you OP

--
HTH

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


Replace @mailinator.com with @tiscali.co.uk

"Sandy Mann" wrote in message
...
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.- Hide quoted text -

- Show quoted text -