Thread: IF and AND function with COUNTIF to calculate only populated cells
View Single Post
 
Old 05-11-2023, 10:48 PM
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
Instead COUNTIF use COUNTIFS - it allows many conditions to be applied. E.g.:
Code:
To count home games
=COUNTIFS($C$5:$C$346,$BQ7,$B$5:$B$346,">0")
To count away games
=COUNTIFS($H$5:$H$346,$BQ7,$B$5:$B$346,">0")
Reply With Quote