I'm trying to do a simple SUMIF formula but it isn't working and I think it is because I'm trying to use a number as the criteria. But I would think there is a workaround.
My main sheet has data like the below, where the same C/M is listed multiple times with different actual amounts.
On a separate sheet, I want to sum all the actual amounts for each C/M and tried the below but it results in a $0. But the result should be $17.00.
Any thoughts on what I am doing wrong?
