Microsoft Office Forums - View Single Post - COUNTA and IF? Possibly

Thread: COUNTA and IF? Possibly

View Single Post

Old

10-06-2015, 08:34 AM

shg

shg is offline

shg uses Windows 7 64bit

Windows 7 64bit shg uses Office 2010 32bit

shg uses Office 2010 32bit

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