# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.