Counting cells with date match criteria

[SerenaRian]

Hi there,

I am having trouble with a counting formaula and could use some advice.

I need to count the number of donations (each row is a donation), but only of certain sources (for the example table below lets say only source A and B), but only when the Close Date matches the First Donation Date are the same.

[TABLE="width: 200"]
<tbody>[TR]
[TD]Close Date[/TD]
[TD]First Donation Date[/TD]
[TD]Source[/TD]
[/TR]
[TR]
[TD]22/05/2015[/TD]
[TD]13/05/2015[/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]01/09/2015[/TD]
[TD]22/05/2015[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]01/09/2015[/TD]
[TD]01/09/2015[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]28/07/2016[/TD]
[TD]22/05/2015[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD]24/12/2016[/TD]
[TD]24/12/2016[/TD]
[TD]A[/TD]
[/TR]
</tbody>[/TABLE]

Could someone help with this?

Thanks!
Serena

 

[Eric W]

Welcome to the Board!

Try:

=SUMPRODUCT(--($A$2:$A$6=$B$2:$B$6),--ISNUMBER(MATCH($C$2:$C$6,{"A","B"},0)))

You could put the sources in a table somewhere too, it would make it easier to change if you want a different set of parameters.

 

[SerenaRian]

Works perfectly, thank you so much Eric!

Serena

 

[Eric W]

Happy to help!