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

None of the "blank" cells in the Sample tab are blanlk, try it like

Formula:

Please Login or Register  to view this content.

I initially populated it from a cohort sheet containing the dollars. Then I simply converted some of the numbers.

That is weird on the blank cells.

Did you originally have formulae that returned "", which were then copy/pasted as values?
If so that is what is causing the null strings to be in the cells.

That seems to work! Thanks much Fluff13. I don't fully understand Sumproduct.

You're welcome & thanks for the feedback.

How do I mark as solved?

Done. Thanks!