Summing Vlookups together

[RocketRat]

Problem: I need to add additional logical to the Formula
below but I am running out of space.

Question: Is there a way to reduce the siz of the forumla
(ie. have the Vlookup sum a range instead of adding
individual vlookup for each cell)

Formula:

=IF(C6=0," ",IF(AND(F6=6,E7-E6=6),VLOOKUP(E6,ACF!
$G$10:$U$5000,15)+VLOOKUP(E6+1,ACF!$G$10:$U$5000,15)
+VLOOKUP(E6+2,ACF!$G$10:$U$5000,15)+VLOOKUP(E6+3,ACF!
$G$10:$U$5000,15)+VLOOKUP(E6+4,ACF!$G$10:$U$5000,15)
+VLOOKUP(E6+5,ACF!$G$10:$U$5000,15),IF(AND(F6=5,E7-
E6=5),VLOOKUP(E6,ACF!$G$10:$U$5000,15)+VLOOKUP(E6+1,ACF!
$G$10:$U$5000,15)+VLOOKUP(E6+2,ACF!$G$10:$U$5000,15)
+VLOOKUP(E6+3,ACF!$G$10:$U$5000,15)+VLOOKUP(E6+4,ACF!
$G$10:$U$5000,15),IF(AND(F6=4,E7-E6=4),VLOOKUP(E6,ACF!
$G$10:$U$5000,15)+VLOOKUP(E6+1,ACF!$G$10:$U$5000,15)
+VLOOKUP(E6+2,ACF!$G$10:$U$5000,15)+VLOOKUP(E6+3,ACF!
$G$10:$U$5000,15),IF(AND(F6=3,E7-E6=3),VLOOKUP(E6,ACF!
$G$10:$U$5000,15)+VLOOKUP(E6+1,ACF!$G$10:$U$5000,15)
+VLOOKUP(E6+2,ACF!$G$10:$U$5000,15),IF(AND(F6=2,E7-
E6=2),VLOOKUP(E6,ACF!$G$10:$U$5000,15)+VLOOKUP(E6+1,ACF!
$G$10:$U$5000,15),VLOOKUP(E6,ACF!$G$10:$U$5000,15)))))))

Tried this but didnot work:

=IF(C5=0," ",IF(AND(F5=6,E6-E5=6),VLOOKUP((E5:E5+5),ACF!
$G$10:$U$5000,15),IF(AND(F5=5,E6-E5=5),VLOOKUP
((E5:E5+4),ACF!$G$10:$U$5000,15),IF(AND(F5=4,E6-
E5=4),VLOOKUP((E5:E5+5),ACF!$G$10:$U$5000,15),IF(AND
(F5=3,E6-E5=3),VLOOKUP((E5:E5+2),ACF!$G$10:$U$5000,15),IF
(AND(F5=2,E6-E5=2),VLOOKUP((E5:E5+1),ACF!
$G$10:$U$5000,15),VLOOKUP(E5,ACF!$G$10:$U$5000,15)))))))