Hello -

I am struggling with a complicated formula. Any help is greatly appreciated.

Calculation intent -
  1. Look for items in column F that do not contain the letter "X" or a hyphen "-". And. . .
  2. Look for items in column C that contain the word "Tangible" and sum applicable items in column AG and multiply by defined variable "TaxTan"
  3. Then add that to ...
  4. Look for items in column F that do not contain the letter "X" or hyphen "-" And. . .
  5. Look for items in column C that contain the word "Intangible" and sum applicable items in column AG and multiply by defined variable "TaxIntan"
  6. Then multiply the total sum by defined variable GA

Here is my stab at it and it is obviously not working.

=IF(AND($F$9:$F$113<>"*X*",$F$9:$F$113<>"-",$C$9:$C$113="Tangible"),SUM($AG$9:$AG$113)*TaxTan,0)+IF(AND($F$9:$F$113<>"*X*",$F$9:$F$113<>"-",$C$9:$C$113="Intangible"),SUM($AG$9:$AG$113)*TaxIntan,0)*GA

Thanks in advance.