SOLVED

SUMPRODUCT, COUNTIF &/OR TELL ME WHAT TO USE PLEASE - FORMULA HELP NEEDED

Copper Contributor

I have a column with many dates, such as: 10/01/22, 05/04/23, etc.  I have another column with text names.  I want the total number of matches for a specific text "  " that have a 2022 associated date.  I then want to do the same thing but for 2023.  The date field column has the the full date and not just the year.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@JohnT2680 

=SUMPRODUCT(($B$2:$B$23=E2)*(YEAR($A$2:$A$23)=D2))

Maybe with this formula. 

That worked. You are the best!! I was trying to figure this out for over two hours. Thank you so much!
1 best response

Accepted Solutions
best response confirmed by Hans Vogelaar (MVP)
Solution

@JohnT2680 

=SUMPRODUCT(($B$2:$B$23=E2)*(YEAR($A$2:$A$23)=D2))

Maybe with this formula. 

View solution in original post