Formula should return a result but doesn't

G

Guest

When I bring up the formula box for the following formula (attempting to sum
up numbers in a different sheet given various conditions) --

=SUM(IF(Sheet1!F2:F1900='1340 - 001'!B8,IF(Sheet1!D2:D1900='1340 -
001'!C8,IF(Sheet1!C2:C1900='1340 - 001'!F8,IF(Sheet1!G2:G1900='1340 -
001'!G6,Sheet1!J2:J1900,0),0),0),0))

it shows 'Formula Result'=69, which is correct, that's what it should be.
But in the cell itself, it will only show 0. I have this problem with most
complex formulas. In a related note, complicated formulas in old
spreadsheets work but if I go in there and say, erase a number and then put
it back, it has the same problem as above. Help!!
 
G

Guest

With all the conditions that I have set up in this formula, setting it up
this way gives me needed flexibility. This formula would work in an older
version of Excel but not in Excel '03. What is it about Excel '03 that is
giving me these problems?
 
M

Morrigan

Is this what you want:

=SUMPRODUCT(--(Sheet1!F2:F1900='1340
001'!B8),--(Sheet1!D2:D1900='1340 - 001'!C8),--(Sheet1!C2:C1900='1340
001'!F8),--(Sheet1!G2:G1900='1340 - 001'!G6),Sheet1!J2:J1900
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula, Partial word, SUM function as result 1
how do I create a nonadjacent series for autofill to go by? 3
Still need help with IF and Count Function 11
Multiple variables to sort and sum, return values<0 with sum refer 5
easy if statement formula 2
result should equal a blank field 2
If function returns #REF!, want it to return 0 2
Vlookup Twist: retrieve one value based on Multiple criteria 5

Top