Combining multiple formulas

Hi all,

I have the following formulas:-

=IFERROR(SUM(IF(SUM(F11*24)<VLOOKUP($C11,$F$1:$O$6,3),VLOOKUP($C11,$F$1:$O$6,3),SUM(F11*24))-VLOOKUP($C11,$F$1:$O$6,3)),"")

=IFERROR(SUM(IF(SUM(G11*24)<VLOOKUP($C11,$F$1:$O$6,3),VLOOKUP($C11,$F$1:$O$6,3),SUM(G11*24))-VLOOKUP($C11,$F$1:$O$6,3)),"")

I have the same formula seven times with the cell reference at the first part of the formula continuing alphabetically H, I, J, K, L, M.

Currently, I have each formula in it's own cell but I'd like to just SUM the results of each formula in one cell as one long formula.

I've tried a simple =sum((formula1)+(formula2)) etc but this results in error.

I've attached the example. The formulas are in columns Z:AF.

Please can someone help.
Thanks,

you are putting iferror formula with "" (text) that is why it is happening you need to change with 0(zero) and now you will surly club your formula.

Cheers
Ankur

Schoolboy error - Thank you.