Thread: Average on conditional formatted cells
View Single Post
 
Old 02-10-2019, 04:13 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Code:
=SUMIFS(ValuesColumn, CriteriaColumn, CriteriaValue)/COUNTIFS(CriteriaColumn, CriteriaValue)
In case you have several criteria columns, you add additional ",CriteriaColumn, CriteriaValue" pairs into both SUMIFS() and COUNTIFS() part of formula.
Reply With Quote