Additions to an Array Formula (HELP)

I'm currently using the following formula to compute the sum of specific data within a sheet:

=SUM(IF(((D4:D988=70000)+D4:D988=72000))>0,IF(F4:F988>30,30,F4:F988),IF(((D4:D988=71000)+D4:D988=73000))>0,IF(F4:F988>60,60,F4:F988),IF((D4:D988=75000),IF(F4:F988>15,15,F4:F988)))))

I have additional data I now need to add to this formula, but I'm uncertain of how to add it to my current array formula. I need the array formula to sum the duration in column F for any codes "90899" in column D. I don't have any additional criteria for this addition.

How do I go about inserting such an addition. The original array works perfect, but I need this additional criteria added. Does it matter where in the current formula I should place this addition? PLEASE HELP!

I have attached the file for your review. I am wanting to sum the duration(COLUMN F) of all 90899 CPT codes(COLUMN D). I need this sum to be added to the current formula in I4. I have attempted to put numerous versions of formulas in there, but keep getting the message "too many arguments for this function". I hope this gives enough information for someone to be able to assist me. Thanks!

Hi

Try this

Formula:

Please Login or Register  to view this content.

Note: Your formula has errors!

Sorry
my formula has a mistake
try this

Formula:

Please Login or Register  to view this content.

Jose,

You are a straight up genius! I manually checked it and it works beautifully. Thank you so much!

I am happy to have helped.

Thanks for your feedback and don't forge to mark this thread as SOLVED.