photologue
New Member
- Joined
- Jun 12, 2014
- Messages
- 13
I have the following spreadsheet ...
<colgroup><col><col><col><col><col><col span="3"><col></colgroup><tbody>
</tbody>
AS this spreadsheet will be recording product scrap over time and will have many entries over time, I wanted to do a quick table to show a summary of material and process waste for any given date, my table E1 to H14 above.
Have been playing with sumif and product functions but cannot get a result, for instance in cell G2 :-
If the date in A:A equals the date in E2
and
if the stage in B:B equals "Material"
and
if the product in C:C equals F2
then
sum all the relevant scrap costs from D:D
Help is very much appreciated
A | B | C | D | E | F | G | H | |
1 | Date | Stage | Product | Scrap cost | Date | Product | Material Waste | Process Waste |
2 | 02/07/2014 | Printed | WhiteMug11oz | £1.20 | 02/07/2014 | LuggageTags | ||
3 | 02/07/2014 | Printed | WhiteMug11oz | £1.20 | FridgeMagnets | |||
4 | 02/07/2014 | Printed | WhiteMug11oz | £1.20 | Keyring | |||
5 | 02/07/2014 | Material | WhiteMug11oz | £0.95 | Coaster | |||
6 | 02/07/2014 | Printed | LuggageTags | £1.21 | ToteBag | |||
7 | 02/07/2014 | Printed | LuggageTags | £1.21 | MouseMat | |||
8 | 02/07/2014 | Material | Photopanel10x8 | £4.95 | Jigsaw | |||
9 | 02/07/2014 | Material | Photopanel10x8 | £4.95 | WhiteMug11oz | |||
#N/A | BlackMug11oz | |||||||
#N/A | WhiteMug15oz | |||||||
#N/A | Photopanel7x5 | |||||||
#N/A | Photopanel10x8 |
<colgroup><col><col><col><col><col><col span="3"><col></colgroup><tbody>
</tbody>
AS this spreadsheet will be recording product scrap over time and will have many entries over time, I wanted to do a quick table to show a summary of material and process waste for any given date, my table E1 to H14 above.
Have been playing with sumif and product functions but cannot get a result, for instance in cell G2 :-
If the date in A:A equals the date in E2
and
if the stage in B:B equals "Material"
and
if the product in C:C equals F2
then
sum all the relevant scrap costs from D:D
Help is very much appreciated