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.