Sumproduct and Sumif

Hi All!

My data:

Column A is the category name

Column B,C,D is the month (Apr,May,Jun)

How can i sumif the multiple of Column (Apr, May, Jun) in one formula (Perhaps SUMPRODUCT) by specific category name.

Recently, i am using SUMIF(APR) + SUMIF (MAY) + SUMIF (JUN), however i found it very inefficient. i was wondering if i can combine SUMPRODUCT and SUMIF. But I have no idea how it works.  

Please help!

Thanks in advance.

By: Edward Tan

Leave a Reply

Your email address will not be published. Required fields are marked *