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.
Thanks in advance.
By: Edward Tan