Schedule Breakdown

[markusvirus]

Hi Experts,

Can someone help me get the necessary data from my file attached. I have raw data on one sheet and the report should go to the other. I've inserted comments on the cells in "Report" sheet for what I need to get done.

[cbatrody]

Hi,

Please see the attached file.

I have used the following formulae:

In cell (Report) B3: (Array Entered - CTRL+SHIFT+ENTER)
=MIN(IF(RAW!$A1:$A$15401=Report!$A3,IF(RAW!$C$1:$C$15401=Report!B$1,RAW!$I$1:$I$15401,""),""))


In cell (Report) C3: (Array Entered - CTRL+SHIFT+ENTER)
=MAX(IF(RAW!$A$1:$A$15401=Report!$A3,IF(RAW!$C$1:$C$15401=Report!B$1,RAW!$J$1:$J$15401,""),""))

In cell (Report) D3:
=SUMIFS(RAW!$H$1:$H$15401,RAW!$A$1:$A$15401,Report!$A3,RAW!$C$1:$C$15401,Report!B$1,RAW!$B$1:$B$15401,"Lunch Break*")

In cell (Report) E3:
=SUMIFS(RAW!$H$1:$H$15401,RAW!$A$1:$A$15401,Report!$A3,RAW!$C$1:$C$15401,Report!B$1,RAW!$B$1:$B$15401,"Break*")

In cell (Report) F3:
=C3-B3

[markusvirus]

Hi cbatrody,

Thank you so much for spending time regarding my post. I tried to drag the formulas but it caused the other rows to have "N/A". Though it worked for the first three dates on the first row.

[cbatrody]

Please check the attached file.

Only change is formula in B3 (as following):

=MIN(IF(RAW!$A$1:$A$1182=Report!$A3,IF(RAW!$C$1:$C$1182=Report!B$1,RAW!$I$1:$I$1182,""),""))

(Array entered - CTRL+SHIFT+ENTER)

As the file size was huge, I had deleted significant number of rows from the source file so that I could upload the file in here.

[markusvirus]

thank you so much cbatrody!

[markusvirus]

cbatrody,

Can you look at the formula again? When I added data, it seems to be unable to get the computation from the initial file.

[cbatrody]

The formula needs to be modified to cover the complete data range in places highlighted below:

$A$1:$A$6053
$C$1:$C$6053
$I$1:$I$6053