Forum Discussion
Solved
Combinating of sumifs and countifs.
Hi, I Countifs with criterias "BCT", "LT", "232A01" (1). Sumifs of sales for that criterias( 2). The expected result:= (2)/(1) Hope for your help Thank you.
It looks like we need to check Position in the current row to receive expected result (row at the bottom)
=IF( OR([@Position] = {"BCT", "LT"}), SUM(SUMIFS([Sales], [ID], [@ID], [Position], {"BCT", "LT"})) / SUM(COUNTIFS([ID], [@ID], [Position], {"BCT", "LT"})), 0 )
=SUM(SUMIFS([Sales],[ID],[@ID],[Position],{"BCT","LT"}))/SUM(COUNTIFS([ID],[@ID],[Position],{"BCT","LT"}))
It looks like we need to check Position in the current row to receive expected result (row at the bottom)
=IF(
OR([@Position] = {"BCT", "LT"}),
SUM(SUMIFS([Sales], [ID], [@ID], [Position], {"BCT", "LT"})) /
SUM(COUNTIFS([ID], [@ID], [Position], {"BCT", "LT"})),
0
)Thank you very much. It's worked
littlevillage , glad to help
Detlef_Lewin , that was only my guess. Logic explained in text and logic in sample are not fully identical.
