A quick way of CSR Reporting II Using Excel SUMPRODUCT

Example of SUMPRODUCT function in Excel used for an example from Social Sector. 

Continuing from my previous blog post. I have added a date column. 

Now your manager wants to know the spend on covid relief related activities for January to March of 2021.

You could easily answer the question using SUMPRODUCT function. The expression will look like =SUMPRODUCT(Table1[Amount]*--(Table1[Date]<DATE(2021,4,1))*--(Table1[Date]>DATE(2020,12,31))*--(ISNUMBER((SEARCH("covid",Table1[Purpose],1)))))

The answer is Rs 4,25,000.

I had converted the range in to Excel Table before using it.  

To check if your answer is correct, filter the Date and Purpose column as shown below. Our answer matches and it is correct.

10:59 03-09-2021