Hi
Looking for some advice on how to develop an existing SUMIF formula which will also consider a specific/fixed date - hope someone can assist!!
Please refer to the attached file (cmck_SUM.xlsx). I have created a SUMIF formula in column F ('Total Certificates') which will sum the quantity of certificates in column B (NoOfCertificates') depending on the 'Supplier' (Column E).
However what I want to do is to exclude any certificates from the total in column F if 'NoOfCertificates' (column B) has a corresponding 'Start Date' (column C) which is before/prior to 01/04/2022. (where the date format is UK, DD/MM/YYYY).
I should point out that the attached file is only a small sample - the file I need to create the formula for has thousands of rows, and columns E and F would probably reside on a different sheet but within the same .xlsx workbook. I've only added those columns here for illustration purposes
Help on this would be very much appreciated!!!
Cal
Bookmarks