Count total quantity by date into month [Solved]

Winndixie 23 Posts Monday March 10, 2014Registration date September 28, 2018 Last seen - Sep 25, 2018 at 05:09 AM - Latest reply: ac3mark 10647 Posts Monday June 3, 2013Registration dateModeratorStatus October 15, 2018 Last seen
- Sep 28, 2018 at 04:35 PM
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



See more 

Your reply

3 replies

Best answer
ac3mark 10647 Posts Monday June 3, 2013Registration dateModeratorStatus October 15, 2018 Last seen - Sep 26, 2018 at 01:35 PM
1
Thank you
Why is there two back to back commas [ ',' ] in the formula?

,">="&I$1,,$C$2:$C$19,"
--------------^^--------------------

Thank you, ac3mark 1

Something to say? Add comment

CCM has helped 1296 users this month

Winndixie 23 Posts Monday March 10, 2014Registration date September 28, 2018 Last seen - Sep 28, 2018 at 03:47 AM
Oops!! no wonder the formula didn't work ^^" thanks a lot! i amend it and try again!
thank you very much!!
ac3mark 10647 Posts Monday June 3, 2013Registration dateModeratorStatus October 15, 2018 Last seen - Sep 28, 2018 at 04:35 PM
Not a problem. That is called TPI (two person integrity)! IT is actually more cost effective to have two programmers at each station, one typing the syntax and the other auditing on the fly! In the long run you save money because production time goes down, and bug troubleshooting happens live and real time!
Respond to ac3mark