Shorten Formula

[MStacey]

Please can you help me shorten this formula

The desired result is the TOTAL SUM of the values from spreadsheet 'Month (1)" columns (C8:C400)+(F8:F400)+(I8:I400)+(L8:L400)+(08:O400)

IF(C8="","",SUMIFS('Month (1)'!C$8:C$400,'Month (1)'!B$8:B$400,C8))
+IF(C8="","",SUMIFS('Month (1)'!F$8:F$400,'Month (1)'!E$8:E$400,C8))
+IF(C8="","",SUMIFS('Month (1)'!I$8:I$400,'Month (1)'!H$8:H$400,C8))
+IF(C8="","",SUMIFS('Month (1)'!L$8:L$400,'Month (1)'!H$8:H$400,C8))
+IF(C8="","",SUMIFS('Month (1)'!O$8:O$400,'Month (1)'!N$8:N$400,C8))

 

[Fluff]

You could reduce it slightly like
=IF(C8="","",SUMIFS('Month (1)'!C$8:C$400,'Month (1)'!B$8:B$400,C8)
+SUMIFS('Month (1)'!F$8:F$400,'Month (1)'!E$8:E$400,C8)
+SUMIFS('Month (1)'!I$8:I$400,'Month (1)'!H$8:H$400,C8)
+SUMIFS('Month (1)'!L$8:L$400,'Month (1)'!K$8:K$400,C8)
+SUMIFS('Month (1)'!O$8:O$400,'Month (1)'!N$8:N$400,C8))

I assume the part in red is correct & was a typo in your op

 

[Tetra201]

See if the following formula works for you:

=IF(C8="","",SUM(SUMIFS(OFFSET('Month (1)'!C$8:C$400,,{0,3,6,9,12}),OFFSET('Month (1)'!B$8:B$400,,{0,3,6,9,12}),C8)))