Hi, I have the following equation which seems to not be working - and I'm not sure why, if someone could please help
=SUMIFS('Apr-18'!$CU:$CU,'Apr-18'!$AJ:$AJ,"*"&B4&"*") - doesn't work
=SUMIFS('Apr-18'!$CU:$CU,'Apr-18'!$AJ:$AJ,"310003") when I change the B4 to be the actual cell contents of...