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

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I write a conditional statement in Excel to count if two c. (https://www.excelbanter.com/excel-worksheet-functions/9314-how-do-i-write-conditional-statement-excel-count-if-two-c.html)

marblelife

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

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

Bob Phillips

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

--
HTH

Bob Phillips

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

Dave Peterson

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

is one way

marblelife wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 03:19 AM.