• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

HOW TO USE IF SUMIFS FORMULA

jack999

Member
Hai

How to use If sumifs formula to calculate between period of date.
My worksheet A4:441 has date column. I want combine the below given sumifs formula with the period of date 01/05/2019 to 31/07/2019. The period of date which need to calculate mentioned in H1 and H2.

01/05/19​
31/07/19​

IF H1>=and <=H2, A1:A441 then SUMIFS($L$4:$L$441,$E$4:$E$441,$Q$28,$F$4:$F$441,L5)

Just to add the period of date to sumifs formula SUMIFS($L$4:$L$441,$E$4:$E$441,$Q$28,$F$4:$F$441,L5)

can someone help me
 
Last edited:

jack999

Member
I got the formula =SUMIFS($I$4:$I$441,$E$4:$E$441,$N$28,$F$4:$F$441,M29,$A$4:$A$441,">="&$P$23,$A$4:$A$441,"<="&$P$24)

If any other way to write this formula. Please tell
thanks
 
Top