SUMIF criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-2910658%22%20slang%3D%22en-US%22%3ESUMIF%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2910658%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20column%20with%20dates%20entered%20as%20m%2Fdd%2Fyy.%3C%2FP%3E%3CP%3EI%20have%20another%20column%20with%20revenue.%3C%2FP%3E%3CP%3EI%20need%20a%20formula%20for%20sumif%20that%20will%20only%20sum%20revenues%20for%20the%20specified%20month.%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2910658%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2910743%22%20slang%3D%22en-US%22%3ERe%3A%20SUMIF%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2910743%22%20slang%3D%22en-US%22%3EInstead%20of%20a%20formula%20use%20a%20pivot%20table.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a column with dates entered as m/dd/yy.

I have another column with revenue.

I need a formula for sumif that will only sum revenues for the specified month.

Thanks in advance for your help.

 

2 Replies
Instead of a formula use a pivot table.

@Creosoter

Let's say the dates are in D2:D100 and the revenue in E2:E100.

Cell K1 contains a date in the month you want to look at.

 

=SUMIFS(E2:E100, D2:D100, ">"&EOMONTH(K1, -1), D2:D100, "<="&EOMONTH(K1, 0))