Help request to get a monthwise total of each particulars

Hi friends,
I want to get a monthwise total of each particulars in the table ‘ag:at’.
I have created a dropdown list for each item in cell ‘at3’.
After selecting the item in cell at3 the values in column ‘ag’ changes. For it I have created a dropdown list using indirect reference source cell at3.

After selecting the item and its particulars I want a total of each particulars monthwise in the table range ‘ag:at’.

I used sumif function but it gives me a total of each particulars yearly. I want to get it monthwise.

Any help will be highly appreciated.

Thanking you in anticipation.

Maybe this.....

In AH5

Please Login or Register  to view this content.

then copy across and down.

Hi Sktneer,
Perfect! Thank you for perfect solution.

Have a nice day.

You're welcome. Glad I could help.

Hi Sktneer,
Sorry for trouble you again.

If there are same particulars in any items then the formula takes all of these particulars in total though they are in different items and produce a wrong total. The particulars in column ‘E’ are dependent of items in column ‘D’.

For ex. See a particular ‘Pencil’ which is in both items namely ‘Grocery and Stationary’If I select grocery item then it should take a amount in the month of March only and not in the month of November which is in item stationary.

I amended the formula as below but it’s not giving correct output showing 0 value.

Please Login or Register  to view this content.

Thank you.

I am not surprised.

Please Login or Register  to view this content.

Hello Sktneer,
Excellent! What a perfect solution. You always have a solution for any problem is my experience. Keep it up.

I appreciate you for the same.

Good night!