G
Guest
I have a worksheet that I am using to calculate on time delivery based on
actual ship dates and promised ship dates. I have the countif function
calculating the two dates and giving me my result for each line item. Now
what I need to do is summarize it by day of the month. I have another
worksheet that I'm using to summarize it. What I want to do is have the
summary worksheet look at the ship date column (J) and count up all the
variances greater than 2 in column (K). On the summary worksheet I have a
column list of every day of that particular month so I want put the total for
each day next to the actual day on the summary tab. On the summary tab column
(A) has the day of the month, column (B) is where I want it to put the
countif result for each day. How would I write this formula up?
actual ship dates and promised ship dates. I have the countif function
calculating the two dates and giving me my result for each line item. Now
what I need to do is summarize it by day of the month. I have another
worksheet that I'm using to summarize it. What I want to do is have the
summary worksheet look at the ship date column (J) and count up all the
variances greater than 2 in column (K). On the summary worksheet I have a
column list of every day of that particular month so I want put the total for
each day next to the actual day on the summary tab. On the summary tab column
(A) has the day of the month, column (B) is where I want it to put the
countif result for each day. How would I write this formula up?