Annual Sum with Criterial

[uqls]

Hi
Please can you help me .
My spreadsheet is like this (please see the attached) :

1. Column A : Dates ( Every day's Date ) :
2. Column B : Data numbers (daily value)
3. Column C: Criterial
4. Column G : Is where I want the formula to be: (sum annual according criterial (when it is TRUE only))

The formula must look at column A and C and add up the corresponding data in column B and give me column G for example.

So basically I need to get annual sum only when my Criterial is TRUE

Thanks for your time and help.

[Pete_UK]

Try this formula in G3:

=SUMIFS(B:B,C:C,TRUE,A:A,">="&DATE(F3,1,1),A:A,"<="&DATE(F3,12,31))

then copy down as required.

Hope this helps.

Pete

[uqls]

Many Thanks

[Pete_UK]

You're welcome - thanks for the rep.

Pete