Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum of 3 nos. into 1 cell in another sheet relevant to specific da
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell linked to a range of cell values in different sheet | Excel Discussion (Misc queries) | |||
Chart Title or Text Box Linked to cell & sheet | Charts and Charting in Excel | |||
Same cell added to master summary sheet | Excel Worksheet Functions | |||
referencing a sheet named in a cell then using data from that sheet | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions |