Having troubles subtracting a cell with a "SUMPRODUCT" value with another cell

[pasqualebaldi]

For example, I want C1 to equal "B1-A1". A1 returns a value, (10 for example) from a "SUMPRODUCT" function and B1=100. But C1 keeps equaling 0.

Here is my function in A1:

Please Login or Register  to view this content.

[teylyn]

Hello,

why wrap the Sumif in Sumproduct? Can you post a data sample, please? It's hard to picture what you are trying to achieve.

[pasqualebaldi]

Here is an example file of what I am trying to do. I am using the "SUMPRODUCT" to search through all my sheets to find a value and return the value in the column next to it, as you will see in the "Total Quantities" sheet. I also have been having some trouble with my "SUMPRODUCT" function. Everything seems correct, but it is no longer returning a value. Could you please help me with that too?

SAMPLE-A.xlsm

Thank you

[teylyn]

You have a circular reference. Remove the "Total Quantities" from the list of sheets.

[pasqualebaldi]

Of coarse. I didn't notice the error until I closed the file and re-opened it.

Thank you very much!