Hi,
Just looking to see if there is a method to sum values in a range between recurring words in a separate column.
I am trying to use one column for the formula in the total column. So far "=IFERROR(IF($B4*$C4=0,0,$B4*$C4),0)" is in column D with some conditional formatting. I would like to sum together the values for each transfer in the same row as "Transfer Note :" in column D.
Thank you in advance for any assistance.
<tbody>
</tbody>
Just looking to see if there is a method to sum values in a range between recurring words in a separate column.
I am trying to use one column for the formula in the total column. So far "=IFERROR(IF($B4*$C4=0,0,$B4*$C4),0)" is in column D with some conditional formatting. I would like to sum together the values for each transfer in the same row as "Transfer Note :" in column D.
Thank you in advance for any assistance.
A | B | C | D | |
1 | Name | Quantity | Cost | Total |
2 | Transfer Date : | 24/01/2019 13:45:15 | ||
3 | Transfer Note : | Freddy | ||
4 | Pencil | 10 | 2.50 | 25.00 |
5 | Soda | 3 | 4.00 | 12.00 |
6 | Transfer Date : | 24/01/2019 13:43:21 | ||
7 | Transfer Note : | Sherise | ||
8 | Chips | 6 | 5.30 | 31.80 |
9 | Transfer Date : | 23/01/2019 10:15:54 | ||
10 | Transfer Note : | Terry | ||
11 | Soda | 2 | 4.00 | 8.00 |
12 | Lollies | 8 | 8.20 | 16.40 |
13 | Transfer Date : | 23/01/2019 09:58:30 | ||
14 | Transfer Note : | Steve | ||
15 | Paper | 13 | 0.17 | 2.21 |
16 | Beanie | 2 | 12.50 | 25.00 |
17 | Milk | 5 | 3.75 | 18.75 |
18 |
<tbody>
</tbody>