Need Formula help to pull data.

[Mykahlia]

Hello,

I am wondering if anyone can help me figure out a formula that will pull the data and sum the total of that data in to another sheet. This is the formula I have been trying to work with. =SUMIFS('Class dates lookup'!G$2:G,'Class dates lookup'!L$2:L,B3,'Class dates lookup'!B$2:B,"<>",'Class dates lookup'!B2:B,"<"&Toay(),'Class dates lookup'!B2:B,">="&IF(WEEKDAY(TODAY())=2,TODAY(),TODAY()-WEEKDAY(TODAY()-2))).

The criteria I need is the data from one sheet based on specific information pulled to another sheet. Example pics - This is where the Data is. I need to pull the Planned data to another sheet and sum it, based off the Site, Class Type and the Start Date. This sheet is called 'Class dates lookup.'

The data needs to pull to this sheet where it is based off a weekly calander that starts on Monday of each week and goes to Sunday. It is broken down by class type and by site. This sheet is called FTE.

Previous weeks and quarters we have been doing it by hand but want to be able to have a formula pull the data. Any help on this is greatly appreciated. I have been pulling my hair out trying to get it to work. When I load the formula above, I get a #name? error. Thank you in advance for any help offered.

 

[johnny51981]

You can do a SUMIFS like this for your weekly formula...apologies if it isn't exact, but should give you an idea.

SUMIFS('Class dates lookup'!$H:$H, 'Class dates lookup'!$G:$G, 'Weekly Summary'!$D3, 'Class dates lookup'!$L:$L, 'Weekly Summary'!$E3, 'Class dates lookup'!$B:$B, ">="& 'Weekly Summary'!BE$2, 'Class dates lookup'!$B:$B, "<"& 'Weekly Summary'!BF$2)

 

[Mykahlia]

You can do a SUMIFS like this for your weekly formula...apologies if it isn't exact, but should give you an idea.

SUMIFS('Class dates lookup'!$H:$H, 'Class dates lookup'!$G:$G, 'Weekly Summary'!$D3, 'Class dates lookup'!$L:$L, 'Weekly Summary'!$E3, 'Class dates lookup'!$B:$B, ">="& 'Weekly Summary'!BE$2, 'Class dates lookup'!$B:$B, "<"& 'Weekly Summary'!BF$2)

Thank you for your help but this did not work. I need column H data on the Class date lookup summed together and put in column BE on the FTE sheet. The summed total needs to be based off the site which is column G which could be MNL or NIC, the class type which is column F which could be Full S&S or Abbr. S&S. and then it needs to pull the total from the dates example 3/31/2025 to 4/06/2025.

 

[JMan1984]

Good Evening Mykahlia,

There is a typo in your formula. You are missing the "d" in one of your today() functions and have toay() instead. This would generate a name error I believe. Can you try updating your formula and see if that works for you?