I need an equation that gives me a count of every 22 products (Column E) from the number days/dates given. Also I need an equation that continues on from the difference in Column F.
Please see attached.
Thank you.
I need an equation that gives me a count of every 22 products (Column E) from the number days/dates given. Also I need an equation that continues on from the difference in Column F.
Please see attached.
Thank you.
in E3
=INT(SUM(D$2:D3)/22)
in F3
=SUM(D$2:D3)-E3*22
and copy down
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
That equation did not work.
---------- Post added at 06:50 PM ---------- Previous post was at 06:44 PM ----------
I came up with this equation, but it gets me a wrong number when I decrease the division to 10 products per.
and this in E2...
=IF(SUM($C$2:C2)>=22,INT(SUM($C$2:C2)/22,"")
and this in F2...
=IF(SUM($C$2:C2)>=22,MOD(SUM($C$2:C2),22),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks