If data exists, use

[JT101]

I have different numbers in columns A, B and C such as this:

A B C
6.139 8.562
6.139 0.255
6.139 2.8
8.797 2.8
8.797 2.8

There is only ever data in B or C, never both. How do I sum A * (B or C) into column D?

Thanks

[OllieB]

Maybe using the following formula

Please Login or Register  to view this content.

[JT101]

Thanks Ollie. That worked a treat