Help with SUMIF for good karma
The below formula isn’t working and I think it’s because the last argument is a range. Can anyone help me find a solution that will work please?
=SUM((‘2024’!$S$2:$CH$255)*(–(‘2024’!$H$2:$H$255=Mappings!$C19)))*(–(‘2024’!$S$2:$CH$2=Mappings!$B$37:$B$50))
The below formula isn’t working and I think it’s because the last argument is a range. Can anyone help me find a solution that will work please? =SUM((‘2024’!$S$2:$CH$255)*(–(‘2024’!$H$2:$H$255=Mappings!$C19)))*(–(‘2024’!$S$2:$CH$2=Mappings!$B$37:$B$50)) Read More
