extract and add information

[djay1991]

I'm only an occasional user excel. Mainly at home sometimes for my place of employment. I'm building a budget and I am trying to figure out how to extract and add information. Specifically:
In column A I have the amount paid in column B I have the date I paid it.
I want to find all my payments for a given month and add them together.

The amount of payments I have in any given month vary.

 

[Marcílio_Lobão]

djay1991, Good afternoon.

Try to use:

=SUMPRODUCT((MONTH(B1:B100)=1)*(A1:A100))

Month = 1 = January

Is that what you want?

I hope it helps.

 

[djay1991]

That's working. Thanks

 

[Marcílio_Lobão]

djay1991, Good afternoon.

Glad to have helped you.

Thanks for the feedback.