I want to sumif "store purchases" for Jan. in excel 2003 could someone please show me how to do this
I want to sumif "store purchases" for Jan. in excel 2003 could someone please show me how to do this
Hi
an example: numbers in B1:B10, dates (real dates) in A1:A10.
To sum numbers related to january 2019
=SUMPRODUCT((MONTH(A1:A10)=1)*(YEAR(A1:A10)=2019)*B1:B10)
If there is no need to filter the year
=SUMPRODUCT((MONTH(A1:A10)=1)*B1:B10)
Hope it could be of some help.
Last edited by canapone; 04-03-2019 at 09:34 AM.
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
ill try it now thanks ill let you know if it works for me
Here is a copy of my file. Go to the summary worksheet and in cell B13, I want a formula to sum the CATEGORIES with each MONTH as listed in the headings. Thanks
I use the 2017,2018,2019 worksheets for the corresponding table on the summarry worksheet
Hi,
a quick example before getting stuck in my daily florentine traffic jam.
In B53 to be copied across
=sumproduct(('2019'!$B$3:$B$100=$A53)*(month('2019'!$A$3:$A$100)=column(A$1))*'2019'!$D$3:$D$100)
The segment
=column(A$1)
if copied to the right produces 1-2-...12 the numbers represent - of course- months passing by...
Please forgive my bad English
Change the headings in row 52. For example, instead of January, type 01/01/2019 and then set the formatting to custom > mmmm.
Now you can use the MONTH function to create the date criterion for your formula.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Wow this works great Canapone copied down and over thank you so much for your help
I will also try changing the row heading like you suggested AliGW
Thank you both so much for helping me with this problem I really appreciate it
No problem!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks