Formula for sheet summary field to count dates in column

jeanniesry_4

Hello,

Can someone help direct me to the right formula for counting the number of dates entered in one column where selected criteria in a second column applies?

I tried this but can't get it to work when I add the AND CONTAINS to the function.

=COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F52", AND(CONTAINS([Site Rec'd:]:[Site Rec'd:], "F03")))

I want to get the count on the "[Date MP Reviewed (Kite CoA Quality Appr) / to QA:]" when "[Site Rec'd:]" is F03, F06, F08,and F52.

Bassam Khalil

Hi @jeanniesry_4,

please try the following formula :

=COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F52") 
+ COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F03") 
+ COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F06") 
+ COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F08")

Bassam Khalil

Hi @jeanniesry_4,

please try the following formula :

=COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F52") 
+ COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F03") 
+ COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F06") 
+ COUNTIFS([Date MP Reviewed (Kite CoA Quality Appr) / to QA:]:[Date MP Reviewed (Kite CoA Quality Appr) / to QA:], <>"", [Site Rec'd:]:[Site Rec'd:], "F08")

jeanniesry_4

@Bassam Khalil - it works!! thank you so much