Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page IF and AND function with COUNTIF to calculate only populated cells
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2023, 10:48 PM
ArviLaanemets ArviLaanemets is offline IF and AND function with COUNTIF to calculate only populated cells Windows 8 IF and AND function with COUNTIF to calculate only populated cells Office 2016
Expert
  
Join Date: May 2017
Posts: 960
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
  #2  
Old 05-12-2023, 03:49 PM
VKiprijan VKiprijan is offline IF and AND function with COUNTIF to calculate only populated cells Windows 10 IF and AND function with COUNTIF to calculate only populated cells Office 2016
Novice
IF and AND function with COUNTIF to calculate only populated cells 		 
Join Date: May 2023
Posts: 15
VKiprijan is on a distinguished road
Default
It works this way as well. Thanks a lot.
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTIF to count long text/values in cells (#VALUE! Error) FrancisSIP Excel 5 10-29-2020 04:00 AM
Naming Documents From Populated Cells TYPOGRAPHICS Word VBA 8 04-08-2016 09:13 AM
Nested Countif Function bdavidson22 Excel 1 12-21-2014 07:55 AM
Nested Countif Function bdavidson22 Excel 0 12-19-2014 12:36 PM
IF and AND function with COUNTIF to calculate only populated cells Countif function not calculating correctly MoranGail Excel 1 07-09-2014 05:50 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:08 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft