SUMIFS is not working for first formula line

[turbalejo]

Hi,

I have a formula to look up a number value based on 4 lines.

=IFERROR(SUMIFS(OFFSET('Weekly Pipeline Report'!$A$2,0,MATCH($C$39,'Weekly Pipeline Report'!$A$1:$AAA$1,0)-1,ROWS('Weekly Pipeline Report'!$A$2:$A$4451),1),
OFFSET('Weekly Pipeline Report'!$A$2,0,MATCH($C$40,'Weekly Pipeline Report'!$A$1:$AAA$1,0)-1,ROWS('Weekly Pipeline Report'!$A$2:$A$4451),1),$E60,
OFFSET('Weekly Pipeline Report'!$A$2,0,MATCH($C$41,'Weekly Pipeline Report'!$A$1:$AAA$1,0)-1,ROWS('Weekly Pipeline Report'!$A$2:$A$4451),1),F$58,
OFFSET('Weekly Pipeline Report'!$A$2,0,MATCH($C$43,'Weekly Pipeline Report'!$A$1:$AAA$1,0)-1,ROWS('Weekly Pipeline Report'!$A$2:$A$4451),1),"<="&F$57,
OFFSET('Weekly Pipeline Report'!$A$2,0,MATCH($C$42,'Weekly Pipeline Report'!$A$1:$AAA$1,0)-1,ROWS('Weekly Pipeline Report'!$A$2:$A$4451),1),"<>0"),0)

Formula set up
Sum column tag	Size (MW)
SUMIF line 1	Stage
SUMIF line 2	Time Date Stamp
SUMIF line 3	EAM
SUMIF line 4	Close Date

<colgroup><col><col></colgroup><tbody>
</tbody>

The formula works great. but.....when I update column tag to a text field, the formula crashes.
How can I update top line, to be able to count text in column?

=IFERROR(SUMIFS(OFFSET('Weekly Pipeline Report'!$A$2,0,MATCH($C$39,'Weekly Pipeline Report'!$A$1:$AAA$1,0)-1,ROWS('Weekly Pipeline Report'!$A$2:$A$4451),1),

racking my brain out as it should be a simple fix.....ugh...
Thank you....