Formula total of selected month in filter

Hello,

See attachment worksheet sample.

First, I need help to set the formula which will total the month that I select in the filter. Let say if I filter the month of January of 2023 that will give me only the total of the cell from D9 only for the January month. Then if I unfiltered by selecting all then it will return to the total including everything feb, march etc. in the column D9.

Second, need also a formula in cell D2,D3,D4,D5 which I also need a total of how many banana, apple or orange total from cell C9 down. Same scenario above when I filtered for the month of January 2023 it will give me the total of how many banana, apple, orange was entered in the C9 and if I unfiltered then it will total up the entire total including all the months.

I am not sure if it needed to have a message box to switch from filter to unfiltered or just a straight formula in cell.
Greatly appreciated in advance.

You can use this formula in D9:

=SUBTOTAL(9,D9:D49)

I'll have to think about part two of your question.

Hope this helps.

Pete

Hi Pete,
The first formula works perfectly

Please Login or Register  to view this content.

Can you please work the second formula with the total of banana, apple....? Thank you in advance.

Pete,
This is what I have so far.

Please Login or Register  to view this content.

The code only work for the entire month but if I filter for specific month like January it does not add up for that month. See attachment.

Hello All,
So far this is what I have but I needed to add to sum up when I filter the month. Let say If I filter the month of January 2023. The total for the month of January 2023 should be 11 but If I unfiltered then the total should be 14 including the Februayr 2023.

Please Login or Register  to view this content.

Please Help! Thank you in advance.

Respond to this: You have blank descriptions in Column C. How are these to be handled? What do they represent?
Sometimes, when I receive a report that when I type the data in. It can be blank sometimes until I received the report.

Hope it answer this question.
Thanks.

Wow! I think this is more confusing for me.

Is there a code that will be similar to this:

Please Login or Register  to view this content.

I am thinking I could just separate and create a new column for just total for when I filter the month.

I tried to add 9 to it as a filter but it did not work.

Thank you

Ok.. Thank you and to all.