Count total quantity by date into month

Hello,

Good Day~

Kindly help to correct the formula for below, I had wrote a formula that to calculate the quantity by month to the order date and also by customer, venue and type but it isn't work.

SUMIFS($E$2:$E$19,$C$2:$C$19,">="&I$1,,$C$2:$C$19,"<"&EOMONTH(I$1,0)+1),$A$2:$A$19,"="&$H1,$B$2:$B$19,"="&$H3,$F$2:$F$19,"="&I$2)

Error pop out said that "You've entered too few arguments for this function"

is it the formula too many or miss out any order?

I tried to use a Pivot Table to create a job that is effective, but when add a new entry there is no automatic update the quantity to the summary.





Your kind help on this are very much appreciated.


thanks & regards