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,
Bookmarks