Calculating month wise total sales of each product

[Niladrichowdhury]

i am sending an attachment with this mail, i want to know the month wise total sales of each product through
this method.please help.please open the attachment Book3.xlsx "Transrawdata" & give me a solution.

[Glenn Kennedy]

Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."

A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.

Since you are a new user of this site, on this occasion, I have changed it for you.

However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.

*Other search engines are available!!!

Regards,

Glenn.

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

[AliGW]

Snap. Glenn!!!

[Glenn Kennedy]

=sumifs($i:$i,$a:$a,$k5,$d:$d,">="&m$4,$d:$d,"<="&eomonth(m$4,0))

[Niladrichowdhury]

thank you

[Glenn Kennedy]

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

[Niladrichowdhury]

Thank you very much, excellent job ! once again many many than x

[Niladrichowdhury]

Hello Sir, Pls see my attachment & Sum (C3:P3) , i can't execute because previous cell value passed through sumifs formula.pls help.

[AliGW]

I answered this in your earlier thread!!!

Your SUMIFS is incorrect. In C3 copied across and down:

=SUMIFS(Sheet2!$G:$G,Sheet2!$B:$B,$B3,Sheet2!$D:$D,">="&C$2,Sheet2!$D:$D,"<="&EOMONTH(C$2,0))

Then in Q3 copied down:

=SUM(C3:P3)

[Niladrichowdhury]

=sum(C3:P3) result coming 0 after executing your formula.

[AliGW]

See post #10. Your SUMIFS formula is incorrect and causing circular reference errors.

[Niladrichowdhury]

i have rectified it what you have given in #10, but not working on sum, sum value coming 0 . you do sum after executing the formula what you given in #10 & see what happen , the sum value would be 0.

[AliGW]

No - see your file attached to my prevous post - I have corrected it for you there.

The SUMIFS you were using was referencing the wrong cells and ranges.

AliGW on MS365 Insider (Windows) 64 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Total Sales Quantity
2	Product	Product Desc.	Feb-22	Mar-22	Apr-22	May-22	Jun-22	Jul-22	Aug-22	Sep-22	Oct-22	Nov-22	Dec-22	Jan-23	Feb-23	Mar-23	Total Sales Quantity
3	PDS01	Notebook Speedy I	230	0	0	0	0	0	0	0	0	0	0	0	0	0	230
4	PDS02	Notebook Speedy II	110	0	0	0	0	0	0	0	0	0	0	0	0	0	110
5	PDS03	PC Thinkbox I	723	0	0	0	0	0	0	0	0	0	0	0	0	0	723
6	PDS04	USB Adaptor	1395	0	0	0	0	0	0	0	0	0	0	0	0	0	1395
7	PDS05	iPhones PX2	67	145	0	0	0	0	0	0	0	0	0	0	0	0	212
8	PDS06	Stereo Kit	419	0	0	0	0	0	0	0	0	0	0	0	0	0	419
9	PDS07	Camera Connector	125	0	0	0	0	0	0	0	0	0	0	0	0	0	125
10	PDS08	USB Storage	915	0	0	0	0	0	0	0	0	0	0	0	0	0	915

Sheet: Transrawdata1

[Niladrichowdhury]

I have given the recent file where the sales quantity of each product from mar-22 to mar-23 is not blank.

[Niladrichowdhury]

Sum result at Q3cell position coming 0 .

[AliGW]

Oh, dear - I'm not getting through!

The SUMIFS that is giving you those results is causing circular reference errors, therefore the total SUM formula will resolve to 0. Look at my version of your workbook where I have corrected it.

Where in the workbook are the (yet to happen!) March 2022 onwards figures coming from?

Basically, your table is all wrong. You cannot have any figures for sales that haven't happened yet.

I think you need to explain in WORDS what those YET TO HAPPEN sales are and where they have come from, then we can fix it. The SUM formula is NOT at fault - your SUMIFS is.

[Niladrichowdhury]

you mean i have to rectify the dates,if the year started from Feb-21 to Jan-22 then the problem would be solved ....right??

[AliGW]

No, you just need to use the formula I gave you. March 2022 onwards will be 0 until you have sales.

Attached is your workbook - I have converted the cells containing the SUMIFS to values and you can now see that the SUM formula is working.

However, as I said, March 2022 onwards should NOT have any sales yet. If you are using the correct SUMIFS, they will show 0 until sales in those months are added.

[Niladrichowdhury]

Should i Upgrade my excel version ??

[AliGW]

you mean i have to rectify the dates,if the year started from Feb-21 to Jan-22 then the problem would be solved ....right??

Do you want the sales for 2021-22? Then YES, of course the column headers need to be correct!!!

By the way, all column headers need to be the FIRST of the month. I've shown how this can be done easily with a formula based on the date in the first column header in the attached.

[AliGW]

Should i Upgrade my excel version ??

No - my Excel 365 shows the same errors because of your mistakes. It is your understanding of what you are doing that needs to be upgraded. Excel is not at fault. It's user error.

[Niladrichowdhury]

Once again Thank you very much Madam, It was very nice experience to talk with you !! , you are very much likely !! Hope i 'll talk with you in coming days. Don't be irritated if i ask you something in future... your rules of explanation is very much presentable !!!! thank you mam !!! have a nice day , good bye for now.

[AliGW]

I am not irritated, nor shall I be, but you do need to think about what you are being told and understand the mistakes you have made. I am always glad to help you.

[Niladrichowdhury]

pls make this post as solved.
or tell me once again how to do it .

[AliGW]

It is marked as solved - you never removed the solved tag.

[Niladrichowdhury]

Thank you, bye !