Forum Discussion

Copper Contributor

Jun 14, 2022

Solved

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 ...

excel

Formulas and Functions

Riny_van_Eekelen
Jun 15, 2022
letiziadistasi Change the last criterion to:
"<="&'AVG Call-Day'!$AT$2

Riny_van_Eekelen

Platinum Contributor

Jun 15, 2022

letiziadistasi Change the last criterion to:

"<="&'AVG Call-Day'!$AT$2

letiziadistasi
Copper Contributor
Jun 15, 2022
Many thanks for your time and help. It’working