Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If formula
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. |