Forum Discussion
Consider all values equal or minor to an another cell
Hello Excel Community, I really need of yours help!
=SUM(SUMIFS(INDEX('Call A-B% 2021'!$A:$J,0,MATCH("Conteggio_Call",'Call A-B% 2021'!A$1:J$1,0)),'Call A-B% 2021'!$C:$C,'AVG Call-Day'!$I2,'Call A-B% 2021'!$I:$I,'AVG Call-Day'!$AT$2))
I am using this formula to be able to sum all the data for the same person that has in the column I('Call A-B% 2021'!$I:$I) a number less than or equal to 24('AVG Call-Day'!$AT$2). The number 24 is a number that changes dynamically each week because it corresponds to the current week number based on today's day.
How can I make excel understand that I need to take into consideration the value THAT IS LESSER OR EQUAL THAN CELL AT$2?
Thanks for your help!
letiziadistasi Change the last criterion to:
"<="&'AVG Call-Day'!$AT$2
- Riny_van_EekelenPlatinum Contributor
letiziadistasi Change the last criterion to:
"<="&'AVG Call-Day'!$AT$2
- letiziadistasiCopper ContributorMany thanks for your time and help. It’working