Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page COUNTA and IF? Possibly
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 10-05-2015, 02:39 AM
macropod's Avatar
macropod macropod is offline COUNTA and IF? Possibly Windows 7 64bit COUNTA and IF? Possibly Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,521
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try something like:
=SUMPRODUCT((AE:AE="JOHN")*(AF:AF<> 0))
where AF is the column containing the completion dates.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 10-06-2015, 08:34 AM
shg shg is offline COUNTA and IF? Possibly Windows 7 64bit COUNTA and IF? Possibly Office 2010 32bit
Advanced Beginner
  
Join Date: Oct 2015
Posts: 55
shg is on a distinguished road
Default
An alternative to avoid processing the entire column:

=COUNTIFS(AE:AE, "JOHN", AF:AF, ">0")
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
COUNTA and IF? Possibly CountA function to Count Blanks Alaska1 Excel 10 02-11-2015 04:20 PM
COUNTA and IF? Possibly Is it possibly to lock a table ? spookiepower Word 2 09-07-2013 08:55 AM
COUNTA function returns incorrect value joeller Excel 2 10-16-2012 05:37 AM
Advanced ToC problem (possibly) norby Word 4 05-08-2012 12:02 AM
Possibly a VLookup mrswarrick Excel 3 01-13-2012 11:12 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:06 AM.

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