Formula for adding all figures associated to a specific date

WolfPack

Good Day,

I would like to add up all the "Cost Price KES" amounts associated to a specific "Delivery Date".

I am trying with the current formula =SUMIF([Cost Price KES]5:[Cost Price KES]652, [Delivery Date]5:[Delivery Date]652 = 4 / 1 / 22) which is not working.

Can someone please assist me??

Thanks!

Paul Newcome

Try this...

=SUMIFS([Cost Price KES]5:[Cost Price KES]652, [Delivery Date]5:[Delivery Date]652, @cell = DATE(2022, 04, 01))