Sumif(Text(Range,"mmmm"),"January",Range) does not work

[kornsatu]

Hi,

I have 2-column data record (hourly data in 1 year = 8760 rows), for example:

Column 1 Column 2
1/1/2018 00:00 15
1/1/2018 01:00 20
1/1/2018 02:00 5
.
.
.
31/12/2018 23:00 20


Then, I would like to summarize to monthly value.
What I use is
=sumif(text(A2:A8761,"mmmm"),"January",B2:B8761)

it seems to be not working, I don't understand why?

However, I can use {=sum(if(text(A2:A8761,"mmmm")="January",B2:B8761))} which is in this case working fine.
But I would like to know why sumif function does not work

Thank you for your help

 

[kornsatu]

Yes, it returns the range output as text. That's not what SumIf() requires.

SumIf() requires the reference to the range.

Ex.:
A1:C1 have 1,2,3

SumIf(A1:C1,...,...) is OK, the parameter has a reference to the range

SumIf({1,2,3},...,...) does not work. The parameter has the values of the range, not the reference to the range

Very Clear explanation. Now I understood why it does not work.
Thanks a lot

 

[pgc01]

I'm glad it helped. Cheers!