SumIf - Criteria in Column A but SUM Column F

[cbecker831]

A B C D E
Date Expense Vendor Description Amount
6/6/19 Hotel Hilton Customer Visit $450
7/14/19 Hotel Marriott Sales Call $125

There are multiple entries in the table . I'm trying to sum all expenses for June, July, etc. and can't seem to get it.

Using following code: =sumif(A:A, Month(A3)=6,E:E)

Thanks for the help. Searched the forum and couldn't find what I was looking for.

 

[DanteAmor]

You can use a pivot table, check the following example:

https://www.extendoffice.com/documents/excel/2193-excel-group-by-month-year-quarter.html

 

[cbecker831]

Ahhh. Overthought it. Let me try that. Much better solution.

 

[DanteAmor]

Ahhh. Overthought it. Let me try that. Much better solution.

I'm glad to help you. Thanks for the feedback.