Knowledge Base Articles By Category
Recent Forum Posts
=SUM((('CE PCOE PTSA'!M1:M19="SP")+('CE PCOE PTSA'!M1:M19="DP"))*("X"=('CE PCOE PTSA'!AN1:AN19))*(("X"='CE
=SUM(((A2:A19="SP")+(A2:A19="DP"))*(((""(D2:D19))+(""(E2:E19))+(""(F2:F19)))>0)*(B2:B19="X"))
Calculate a total (countifs)
Dear p45cal,
vonryan Today, 01:21 AMI know the use use of whole column references is not a good idea, but I have many sheets that have a different number or rows....