sum values occurring during weekly periods

[Paul15]

Team, I have a working formula counting the number of occurrences of a value "yes" during any weekly period.

=COUNTIFS(CCIC_Log!$C:$C,">="&$A10,CCIC_Log!$C:$C,"<="&$B10,CCIC_Log!$AB:$AB,"Yes")

C: being an event date
A: being week start date
B: being week end date
AB: count all occurrences of "yes" during the weekly period

Where a date in C: falls between start and end dates at A and B, it counts the occurrences of "Yes" between those dates.

I am looking for a way to now 'Sum' values in column CCIC_Log!$P:$P for those same weekly dated periods and where AB: remains "yes". An example might be:

Weekly period
A: 30 Apr 2023
B: 6 May 2023

Between these dates there were entries where AB: "yes" on

C: 1 May 2023
C: 2 May 2023

With value at CCIC_Log!$P:$P being ( ) respectively for those dates

C: 1 May 2023 (10)
C: 2 May 2023 (15)

The formula should return a total of (25)

Hopefully this makes some sense and thanks in advance for any help

regards
Paul

 

[Georgiboy]

Try:

=SUMIFS(CCIC_Log!$P:$P,CCIC_Log!$C:$C,">="&$A10,CCIC_Log!$C:$C,"<="&$B10,CCIC_Log!$AB:$AB,"Yes")

 

[Paul15]

=SUMIFS(CCIC_Log!$P:$P,CCIC_Log!$C:$C,">="&$A10,CCIC_Log!$C:$C,"<="&$B10,CCIC_Log!$AB:$AB,"Yes")

Awesome, works perfectly Many thanks