Hi All,
Hi All,
I need a formula to calculate the following in column D (example of returned info in there):
Only bring across the cost (Col C) info from Red (Col A) that is more than £5.00, all others show 0 inc Red, Blue and Green.
I need it for a summary at the bottom (if possible) or could assign to each column D, which I could SUM at the bottom.
Hope this makes sense?
<tbody>
</tbody>
Cheers
Hi All,
I need a formula to calculate the following in column D (example of returned info in there):
Only bring across the cost (Col C) info from Red (Col A) that is more than £5.00, all others show 0 inc Red, Blue and Green.
I need it for a summary at the bottom (if possible) or could assign to each column D, which I could SUM at the bottom.
Hope this makes sense?
A | B | C | D | |
1 | Red | £2.29 | £2.29 | |
2 | Blue | £5.14 | £0 | |
3 | Blue | £1.01 | £0 | |
4 | Red | £5.85 | £5.85 | |
5 | Green | £10.47 | £0 | |
6 | Red | £9.05 | £9.05 |
<tbody>
</tbody>
Cheers