E
Ellie
I have the following sample sheet:
W/C 12/09 Total Loads Total Cases Failure Loads Failure Cases
12-Sep
13-Sep
14-Sep
15-Sep
16-Sep
0 0 0 0
Having had some fantastic and much appreciated help on the Failure Loads
column, it now seems that the Failure Cases column is to be looked at also.
The above is my 2nd sheet in a workbook, with a 1st sheet containing the
core data. Basically this 2nd sheet is summarising the data entered onto the
1st sheet.
1st sheet is as follows:
Column B = date
Column C = load
Column H = cases per date/load entry
So far I have come up with the following:
=SUMIF(Sheet2!$B$2:$B$9,"12-Sep",Sheet2!$H$2:$H$9) and changing the relevant
date against the subsequent 13-15 Sep entries. This sheet is something that
is looking to become more automated, so would prefer it if either the cell
reference(s) are used instead, but haven't got the relevant knowledge to deal
with this.
The only drawback to this is that for the Friday date, the above e.g. being
16/9, it also needs to incorporate the total number of cases against entries
on sheet 1 for 16-18/9.
Any help would be gratefully received.
Ellie
W/C 12/09 Total Loads Total Cases Failure Loads Failure Cases
12-Sep
13-Sep
14-Sep
15-Sep
16-Sep
0 0 0 0
Having had some fantastic and much appreciated help on the Failure Loads
column, it now seems that the Failure Cases column is to be looked at also.
The above is my 2nd sheet in a workbook, with a 1st sheet containing the
core data. Basically this 2nd sheet is summarising the data entered onto the
1st sheet.
1st sheet is as follows:
Column B = date
Column C = load
Column H = cases per date/load entry
So far I have come up with the following:
=SUMIF(Sheet2!$B$2:$B$9,"12-Sep",Sheet2!$H$2:$H$9) and changing the relevant
date against the subsequent 13-15 Sep entries. This sheet is something that
is looking to become more automated, so would prefer it if either the cell
reference(s) are used instead, but haven't got the relevant knowledge to deal
with this.
The only drawback to this is that for the Friday date, the above e.g. being
16/9, it also needs to incorporate the total number of cases against entries
on sheet 1 for 16-18/9.
Any help would be gratefully received.
Ellie