Sumif question

[sharshra]

I'm using Sumif function to calculate the amount for each year based on the data for months. For doing this, I'm calculating the year based on the months & then using the year for Sumif function. It is giving me the correct result.

However, I would like to avoid calculating the year separately. Instead, would it be better to get the year from the months & use it in the Sumif function?

Sample table is shown below.

At present, I'm using Year() function to calculate the year of the date in a separate column.

=YEAR(B2)

This value of year is used in Sumif function. Instead, wanted to derive year from the date & use it in Sumif function. With this, I need not have a separate column for year.

=SUMIF($D$2:$D$10,G2,$C$2:$C$10)

 

[Fluff]

How about

=SUMIFS(C:C,B:B,">="&DATE(G2,1,1),B:B,"<"&DATE(G2+1,1,1))

 

[sharshra]

Thanks, Fluff. I'm getting 0 when same formula is applied. Not sure what is going wrong

 

[Fluff]

In that case can you post some sample data using the XL2BB add-in.

 

[sharshra]

I have installed XL2BB but 'capture range' is disabled How can I enable it?

 

[Fluff]

Have a look here XL2BB Icons greyed out