# 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

#### Peter Bartholomew

##### Well-Known Member
What you have looks perfectly correct to me. I tend to use tables and structured references but that is largely a matter of taste.