A tricky If/Then formula help needed

[monaPhree]

I'm working on a spreadsheet. In simplest terms,there are four shifts, A,B,C, and D. Each shift enters data into the rows. The data counts how many items of each product was produced on their shift. Each shift enters between 2 to 6 rows of data. It's a live form that runs for 7 days, o shift B, for example, could be on the form in different rows. I need a formula to count the total items produced per shift. Basically: if shift A produced 100 items on April 1st, and the next row shows 200 items ran on the same shift, but it is now April 2nd, then the total for that shift is 300 items.

Or, in different terms, if cell A2 and A3 are the same shift, AND the dates in B2 and B3 are both today OR today and the day before, THEN the total items for that shift are 300. Sorry, if it isn't explained well,and thanks for any help.

 

[HighAndWilder]

I'm working on a spreadsheet. In simplest terms,there are four shifts, A,B,C, and D. Each shift enters data into the rows. The data counts how many items of each product was produced on their shift. Each shift enters between 2 to 6 rows of data. It's a live form that runs for 7 days, o shift B, for example, could be on the form in different rows. I need a formula to count the total items produced per shift. Basically: if shift A produced 100 items on April 1st, and the next row shows 200 items ran on the same shift, but it is now April 2nd, then the total for that shift is 300 items.

Or, in different terms, if cell A2 and A3 are the same shift, AND the dates in B2 and B3 are both today OR today and the day before, THEN the total items for that shift are 300. Sorry, if it isn't explained well,and thanks for any help.

Welcome to MrExcel.

Can you please post valid representations of your data using XL2BB as then developers can use this to come up with a solution?

XL2BB - Excel Range to BBCode

 

[monaPhree]

Welcome to MrExcel.

Can you please post valid representations of your data using XL2BB as then developers can use this to come up with a solution?

XL2BB - Excel Range to BBCode

Yes! I have to wait until I'm back at work because I'm not a high enough level employee to have access to the system from home. I will be working on the sheet this coming Sunday night/Monday morning. Thank you.