Sumif

%3CLINGO-SUB%20id%3D%22lingo-sub-749504%22%20slang%3D%22en-US%22%3ESumif%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749504%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everybody.%3C%2FP%3E%3CP%3EI%20guess%20this%20is%20a%20very%20elementary%20question%20but%20I'm%20not%20able%20to%20find%20the%20right%20grammar%20to%20do%20it.%20So%2C%20I%20have%20a%20column%20of%20dates%20and%20an%20adjacent%20column%20of%20numbers.%20I%20would%20like%20to%20sum%20the%20numbers%20relevant%20to%20the%20same%20month%2C%20let's%20say%20june%20for%20example.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethanks%20a%20lot%3C%2FP%3E%3CP%3EFrancesco%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-749504%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
franchtheone
Occasional Visitor

Hello everybody.

I guess this is a very elementary question but I'm not able to find the right grammar to do it. So, I have a column of dates and an adjacent column of numbers. I would like to sum the numbers relevant to the same month, let's say june for example.

 

thanks a lot

Francesco

1 Reply

@franchtheone 

As one of variants that could be like

=SUMIFS(B:B,A:A,">="&DATE(2019,6,1),A:A,"<"&DATE(2019,7,1))

where year and month better keep as parameters

 

Related Conversations