# Help on if statements calculations or best method

1. ## Help on if statements calculations or best method

Could someone please guide me as to what the best was is to achieve my formula - IF or Sumproduct.

I have atatched the spreadsheet and the desired result in Cell Q16.

The answer should be 73,906. Cell Q15 should be zero and for example Cell Q25 should be 33,529 x 0.9

Any help would be greatly appreciated.

Thanks

2. ## Re: Help on if statements calculations or best method

=IF(I16="yes",INDEX(\$T\$3:\$Z\$3,MATCH(C16,\$T\$2:\$Z\$2,0))*F16,"")
so put in q4 and drag down
=IF(I4="yes",INDEX(\$T\$3:\$Z\$3,MATCH(C4,\$T\$2:\$Z\$2,0))*F4,"")

not everything is in the range t3:z3 like el or dl you'll have to add them and extend the range from t3:z3 to t3:ab3 or bigger

3. ## Re: Help on if statements calculations or best method

Put this formula in cell R4:

Formula:
`Please Login or Register  to view this content.`

then copy it across into S4:Z4. Then copy R4:Z4 down as far as you need to.

Hope this helps.

Pete

EDIT: Ah, slightly misunderstood your requirements, but if you put this in Q4:

Formula:
`Please Login or Register  to view this content.`

along with the other formulae, then you will have your results in column Q.

Pete

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1