SumProduct #Value error

Hello,

I'm pulling my hair out on what seems like should be an easy formula.

I'm using Sumproduct to convert weekly to Monthly data. I have units and dollars.

The Units tab seems to be working fine, but when I plug in inputs from the dollars, I get all #value errors.

I copied the tabs, so all the formulas should be exactly the same, only the inputs are different.

I also tried rounding the the numbers so they were all whole numbers, but that didn't work either.

I think I've attached a file, but I don't see confirmation anywhere.

Any help would be greatly appreciated.

Michael