Inability to Divide two sumifs

[Prof Sick]

I'm trying to divide two sumifs. Excel is returning Div/0 Error. Anybody know of a work around for this issue? Formula below. Formula sit's in cell P4 in the attached workbook.

=SUMIFS(Table1[Value],Table1[LC Month],O5) / SUMIFS(Table1[Lbs],Table1[LC Month],O5)

[JohnTopley]

Month is O4 not O5

[MrShorty]

The critieria argument to both sumifs() is O5 which is blank (0). Because there are not blank/0 values in the LC month column, both sumifs() return 0. So, the sumifs() appear to be working correctly as programmed.

I am guessing that you intended to use O4 as the criteria argument. If that is the case, then the workaround is to use the correct reference in each function in the formula. If I am misunderstanding your intention, then I suggest you explain better what you are trying to do with this formula.

[Prof Sick]

Well thanks.. Excactly what happens after working on something after being awake 24hrs.. Referenced the wrong cell as the criteria argument.

Thanks Again