Question description:
This user has given permission to use the problem statement for this
blog.
Hi,
I have 3 columns A= Dates, B = type, C= amount. I want to sum the amounts if the date has todays month and it is of a certain type. I can't seem to work out the formula. Could you help please?
Solved by K. Y. in 7 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
25/05/2018 - 01:21
Hi
User
25/05/2018 - 01:21
hello
Excelchat Expert
25/05/2018 - 01:21
Welcome to Got It Pro.
Excelchat Expert
25/05/2018 - 01:21
Please share the sample in preview.
User
25/05/2018 - 01:23
So I would like to sum column c if the date matches todays month and column b is "b"
Excelchat Expert
25/05/2018 - 01:23
Ok.
Excelchat Expert
25/05/2018 - 01:23
Only month?
User
25/05/2018 - 01:24
maybe year as well
User
25/05/2018 - 01:24
lets go year and month
Excelchat Expert
25/05/2018 - 01:24
Can i use additional column to get month and year?
User
25/05/2018 - 01:24
yeah of course
Excelchat Expert
25/05/2018 - 01:24
Ok
Excelchat Expert
25/05/2018 - 01:26
=sumifs(C1:C5,B1:B5,"b",D1:D5,year(now()),E1:E5,month(now()))
Excelchat Expert
25/05/2018 - 01:27
I have used sumifs function.
Excelchat Expert
25/05/2018 - 01:27
C:C is sum range and others are criterion range and criterions.
User
25/05/2018 - 01:27
ah i was so close. Thanks so much for your help
Excelchat Expert
25/05/2018 - 01:27
Thank you.
Excelchat Expert
25/05/2018 - 01:28
Please do visit Got It Pro. Have wonderful day ahead.
User
25/05/2018 - 01:28
thanks, you too
Excelchat Expert
25/05/2018 - 01:28
Leave valuable feedback after closing session
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.