How do i do a Date range and countifs formula

Jade

I am new to formulas and need some help with the below:

I have 3 columns called 'campaign', 'actual delivery date' & 'statics'.

I need to create a formula that shows the count of statics per month for every campaign.

I.e. if the campaign is 'b' and the deadline is 1/3/23 it will show me how many statics we did for campaign b in January.

Paul Newcome

Try something like this:

=SUMIFS(Statics:Statics, Campaign:Campaign, @cell = "B", [Actual Delivery Deadline]:[Actual Delivery Deadline], AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))

Paul Newcome

Try something like this:

=SUMIFS(Statics:Statics, Campaign:Campaign, @cell = "B", [Actual Delivery Deadline]:[Actual Delivery Deadline], AND(IFERROR(MONTH(@cell), 0) = 1, IFERROR(YEAR(@cell), 0) = 2023))