SOLVED

excel sum if multiple criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-2308197%22%20slang%3D%22en-US%22%3Eexcel%20sum%20if%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308197%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHi%2C%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20trying%20to%20add%20numbers%20different%20years.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20would%20like%20to%20have%20the%20possibility%20to%20do%20it%20through%20the%20column%20of%20dates%20or%20the%20column%20of%20years.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3ESometimes%20I%20need%20to%20know%20just%201%20year%2C%20others%20a%20range%20of%20years.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20wonder%20if%20someone%20could%20help%20me%20with%20formulas%20so%20that%20i%20do%20not%20have%20to%20put%20%22%26gt%3B%22%20or%20%22%26gt%3B%22%20every%20time%20i%20change%20the%20years.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThank%20you%2C%20Juan%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2308197%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-2308225%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sum%20if%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2308225%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F145009%22%20target%3D%22_blank%22%3E%40juan%20jimenez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20could%20do%20it%20like%20this%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0353.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F276886iC5CC33922B368865%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0353.png%22%20alt%3D%22S0353.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20formula%20in%20I6%20is%26nbsp%3B%26nbsp%3B%20%3DSUMIFS(E%3AE%2CD%3AD%2C%22%26gt%3B%3D%22%26amp%3BH3%2CD%3AD%2C%22%26lt%3B%3D%22%26amp%3BI3)%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309925%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sum%20if%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309925%22%20slang%3D%22en-US%22%3EHans%2C%20it%20works!%3CBR%20%2F%3Edo%20you%20know%20how%20i%20could%20also%20make%20it%20works%20on%20colonne%20C%2C%20where%20i%20have%20the%20exact%20date%3F%3CBR%20%2F%3EThank%20you%20very%20much%2C%20Juan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2309952%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20sum%20if%20multiple%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2309952%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F145009%22%20target%3D%22_blank%22%3E%40juan%20jimenez%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Contributor

Hi,

 

I am trying to add numbers different years.

I would like to have the possibility to do it through the column of dates or the column of years.

Sometimes I need to know just 1 year, others a range of years.

I wonder if someone could help me with formulas so that i do not have to put ">" or ">" every time i change the years.

 

Thank you, Juan

4 Replies
best response confirmed by juan jimenez (Contributor)
Solution

@juan jimenez 

You could do it like this:

S0353.png

The formula in I6 is   =SUMIFS(E:E,D:D,">="&H3,D:D,"<="&I3)

Hans, it works!
do you know how i could also make it works on colonne C, where i have the exact date?
Thank you very much, Juan

@juan jimenez 

See the attached version.

@Hans Vogelaar 

Understood. thant you very much!