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.

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

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: