Hi All,
I'm working with a pretty simple sumifs formula as follows.
=SUMIFS(E4:E77,$A$4:$A$77,">0",$A$4:$A$77,"<=A1")
However, it is returning 0 when there is clearly data. In cell A1 I have the following equation to identify the last number listed in a column that i add data to weekly.
=INDEX('LBI Data'!D:D,COUNT('LBI Data'!D:D,1))
In this case, the formula is returning 45, which shows up in cell A1. Sadly, the sumifs formula doesn't work in this instance. When i replace A1 with 45, the formula works great, so there's some kind of formatting or syntax issue going on, i believe.
I have converted cell A1 to a number in the format cells table, but am still getting 0 returned in my sumifs formula.
Any idea what i might be doing wrong? Thanks for any help!
I'm working with a pretty simple sumifs formula as follows.
=SUMIFS(E4:E77,$A$4:$A$77,">0",$A$4:$A$77,"<=A1")
However, it is returning 0 when there is clearly data. In cell A1 I have the following equation to identify the last number listed in a column that i add data to weekly.
=INDEX('LBI Data'!D:D,COUNT('LBI Data'!D:D,1))
In this case, the formula is returning 45, which shows up in cell A1. Sadly, the sumifs formula doesn't work in this instance. When i replace A1 with 45, the formula works great, so there's some kind of formatting or syntax issue going on, i believe.
I have converted cell A1 to a number in the format cells table, but am still getting 0 returned in my sumifs formula.
Any idea what i might be doing wrong? Thanks for any help!
Last edited: