Count if statement

		Microsoft Office Forums > Microsoft Excel > Excel
Count if statement

10-30-2019, 03:44 AM

p45cal

Windows 10 Count if statement

Office 2019

Expert

Join Date: Apr 2014

Posts: 948

C2:

=IF(MINIFS($A$2:$A$7,$B$2:$B$7,B2)=A2,1,0)
copied down.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting a Select statement in Excel to an update statement	shabbaranks	Excel Programming	5	10-31-2018 11:47 PM
IF statement	mrry475	Excel	1	09-06-2016 09:30 AM
Getting the Count formula to count all rows	Jennifer Murphy	Word Tables	11	08-23-2016 09:37 PM
Count if statement	Alaska1	Excel	7	05-30-2014 08:57 AM
if statement	piper7971	PowerPoint	1	08-19-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:13 AM.