Searching Data for multiple criteria

[Mackay2m]

Hello,

I'm trying to search a table with day/month/year in one column and $ in another column. I want to sum all the total $ for each month in a separate table with the month/year as column headers. I have attached some sample data. Please let me know if you a solution. Excel Test Data.xlsx

[JieJenn]

In D2, enter this formula with Ctrl + Shift + Enter keys together then fill the formula across.

=SUM(IF(YEAR($A$2:$A$42)=YEAR(D$1),IF(MONTH($A$2:$A$42)=MONTH(D$1),$B$2:$B$42,0)))

[José Augusto]

You can use the array formula

Please Login or Register  to view this content.

[nigelbloomy]

You could also do this which doesn't need to be entered as an array. You can just press enter.

Please Login or Register  to view this content.

You are correct JieJenn.

[JieJenn]

Sumproduct is an array formula without the need for CSE keys. Just an FYI.

You could also do this which isn't an array

Please Login or Register  to view this content.

[Mackay2m]

Thanks guys, that worked!