How do I write a conditional statement in Excel to count if two c.

marblelife · Jan 16, 2005

I need to count how many times in a list that a name comes up with a certain
date.

Bob Phillips · Jan 16, 2005

=SUMPRODUCY(--(A1:A100="the_name"),--(b1:b100=--"2004/01/15"))

Dave Peterson · Jan 16, 2005

=sumproduct(--(a1:a10="marblelife"),--(b1:b10=date(2005,1,16))

is one way

Using <= in countifs statement	1	Jan 22, 2018
Function in Excel to count and list number of entries of text valuesin a row.	2	Feb 12, 2014
Count Blank Cells with Conditions	3	Mar 1, 2012
Conditional count	2	Jan 25, 2010
Count Number of Unique Cells That Don't Have Certain Characters	0	Jan 21, 2014
Merging from an Excel file with graphics	1	Aug 24, 2022
Counting cells with conditional formatting	3	Jun 2, 2010
Count partial dates	1	Feb 14, 2012

Ask a Question