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)
[TABLE="width: 234"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Formula set up[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum column tag[/TD]
[TD]Size (MW)[/TD]
[/TR]
[TR]
[TD]SUMIF line 1[/TD]
[TD]Stage[/TD]
[/TR]
[TR]
[TD]SUMIF line 2[/TD]
[TD]Time Date Stamp[/TD]
[/TR]
[TR]
[TD]SUMIF line 3[/TD]
[TD]EAM[/TD]
[/TR]
[TR]
[TD]SUMIF line 4[/TD]
[TD]Close Date[/TD]
[/TR]
</tbody>[/TABLE]
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....
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)
[TABLE="width: 234"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Formula set up[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Sum column tag[/TD]
[TD]Size (MW)[/TD]
[/TR]
[TR]
[TD]SUMIF line 1[/TD]
[TD]Stage[/TD]
[/TR]
[TR]
[TD]SUMIF line 2[/TD]
[TD]Time Date Stamp[/TD]
[/TR]
[TR]
[TD]SUMIF line 3[/TD]
[TD]EAM[/TD]
[/TR]
[TR]
[TD]SUMIF line 4[/TD]
[TD]Close Date[/TD]
[/TR]
</tbody>[/TABLE]
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....