Count by month using 2 worksheets

[AH4039]

Hi - I need some help with a formula....

I want to add a formula to worksheet2 into cells A2 - B2 - C2 etc that adds the values from Worksheet1 column A if the date in column B equals that month of the year.

There will be lots of rows in worksheet1 so the formula needs to include the full column length

example below

Can anyone help please, I just need to get the basic formula working and I can then do the rest?

Worksheet1
Column A - Price (£)
Column B - Date

Worksheet2

A B C 1 Jan Feb Mar
2

 

[jasonb75]

Something like this (for UK dates, format will need changing slightly for US dates).

=SUMIFS(Sheet1!$A:$A,Sheet1!$B:$B,">="&DATEVALUE("1 "&A$2&2021),Sheet1!$B:$B,"<="&EOMONTH(DATEVALUE("1 "&A$2&2021),0))

 

[AH4039]

Something like this (for UK dates, format will need changing slightly for US dates).

=SUMIFS(Sheet1!$A:$A,Sheet1!$B:$B,">="&DATEVALUE("1 "&A$2&2021),Sheet1!$B:$B,"<="&EOMONTH(DATEVALUE("1 "&A$2&2021),0))

Thanks for your help .... I've entered the formula but it returns a 0 value ... I've attached a screen capture to show the example. (I put the formula in sheet2 cell b2 to sum the jan values in sheet1)

I'm using UK dates

 

[jasonb75]

I misread the table in post 1 and saw the column letters as being the first row, with the months in the second row. The 2 references to A2 in the formula need to look to the cell that contains "Jan"

 

[AH4039]

I misread the table in post 1 and saw the column letters as being the first row, with the months in the second row. The 2 references to A2 in the formula need to look to the cell that contains "Jan"

Thanks, that did the trick