HOW TO USE IF SUMIFS FORMULA

[jack999]

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

 

[salim hasan]

Attach the file please

 

[jack999]

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]

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