gobblechops
New Member
- Joined
- Apr 27, 2017
- Messages
- 40
- Office Version
- 365
- Platform
- Windows
Hi all,
I sure this will be an easy task for an expert....
C3:C30 contains prices
D3:D30 contains a name
F3:AH30 contain quantities
For example, row 3 has a name "Ken" in column C, a cost of £2.00 in column D and a varying number of quantities in columns F:AH.
I would like to multiply the cost by the total number of quantity on that row but also sum the total of all the lines with "Ken" using the same criteria as above. Different rows have different costs in column D and different total quantities in the rows.
Thank you in advance!
I sure this will be an easy task for an expert....
C3:C30 contains prices
D3:D30 contains a name
F3:AH30 contain quantities
For example, row 3 has a name "Ken" in column C, a cost of £2.00 in column D and a varying number of quantities in columns F:AH.
I would like to multiply the cost by the total number of quantity on that row but also sum the total of all the lines with "Ken" using the same criteria as above. Different rows have different costs in column D and different total quantities in the rows.
Thank you in advance!