Formula that will transfer data from one sheet and combine based on the group

[jbeets]

Hi Experts!
I am at a complete loss in figuring out how to write the required formula in order to combine some data that I have. I think I will be using an IF or SUMIFS or SUMPRODUCT but I just can’t figure it out. I would really appreciate help in identifying how to write this formula.

I need a formula that will combine and pull in only one instance of each date and interval for each FCST_Group. Like in the example I have under FCST_Group “Group” and then two instances of the date 9/2 with the interval 0 and then in the NCO there are numbers that I will need to then sum. So I need to understand what formula I will use in each column (FCST_Group, Date, Interval) that will give me the results on the “Card” tab. Then in the NCO tab I will need to sum the numbers by interval which I do know should be a SUMIFS.

I know that I can write a nested IF function but I don’t know how to do it without specifying every date and Interval for every group that I have.

I really appreciate any help you can give and thank you for your time!

Jbeets

[JBeaucaire]

I would use a NAMED RANGE to encompass all the data in the sheet dynamically, I added on here called MyTable.

Then I would use that as a PivotTable source to give the layout shown automatically. It's not exactly the same as yours, but it's built in and dynamic.

[azumi]

Hope this works:
(link removed)