Hi
Is there a way to sum one column only if the values in another column are populated?
So in the example below, there are 5 products: A - E in column A.
Column B states whether or not a product is 'Live'
And column C has the sales data for that product.
I'd like to sum up the sales of the products in column C only if there is a value in column B.
So the sum total would be 10 instead of 15.
Has anyone done this before? TIA
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Is there a way to sum one column only if the values in another column are populated?
So in the example below, there are 5 products: A - E in column A.
Column B states whether or not a product is 'Live'
And column C has the sales data for that product.
I'd like to sum up the sales of the products in column C only if there is a value in column B.
So the sum total would be 10 instead of 15.
Has anyone done this before? TIA
Product | Live? | Sales |
A | Yes | 1 |
B | Yes | 2 |
C | Yes | 3 |
D | Yes | 4 |
E | 5 | |
15 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>