If formula problems

[krisryan]

I have to linked workbooks with formulas throughout and no issues however, I need to add a new formula and I can't make it work.

I have attached the work book.

I need tab Total Option 3 B34, C34, D34, E34, F34, G34, H34 to automatically calculate costs according to column Q on tabs OBLIGATEDPARTS, OBLIGATEDSERVICE, INVOICEDB.

So, column Q will always have numbers 3 - 9 and anytime those numbers are entered (into column Q on any of the three tabs) I need the formula to pull the total from Column D and add it to the correct "bucket" Total Option 3 B34 - H34 (CLIN0003, CLIN0004, CLIN0005, CLIN0006, CLIN0007, CLIN0008, CLIN0009. I have spent so much time on this trying to put an IF formula in to make this happen and I am lost! The workbook I need this to happen on is named CLIN TRACKING, the other workbook (parts aging) is only attached because they are linked.

Please let me know if you need more clarification.

Thanks in advance.

[Limor_OP]

How about this in B34:

Please Login or Register  to view this content.

In "OBLIGATEDPARTS", you need to change your formula so that empty cells will show as "0", otherwise it causes errors in the main tab
I changed it to values for the example as I had problems with the linking to the other file.

D6 and down:

Please Login or Register  to view this content.

[krisryan]

How about this in B34:

Please Login or Register  to view this content.

In "OBLIGATEDPARTS", you need to change your formula so that empty cells will show as "0", otherwise it causes errors in the main tab
I changed it to values for the example as I had problems with the linking to the other file.

D6 and down:

Please Login or Register  to view this content.

Thank you so much!