I have a spreadsheet that has an rep log on in column H and a date in column F. This is on Sheet 2
I currently have a count of the number of items a rep has worked on Sheet 1 but I also need a count of items the rep closed. Closed is reflected by the Date in column F. IF Column F is populated with a at I want to get a count on that by rep.
I would believe this is possible somehow but I have hit a wall trying to get there.
Any assistance would be greatly appreciated.
"I'm an idealist. I don't know where I'm going but, I'm on my way." ---carl sandburg
As for using the Sumproduct I have seen that but keep getting an error when I am trying to get the formula for the date column.
If you're using XL 2000, one thing to be careful of is not to use entire column references within SUMPRODUCT because the function will return an error. This rule is true up to and including XL 2003.
Other typical causes of an error return value are error values within the data or not keeping the arrays an equal size (depending on the form of SUMPRODUCT() you are using).
Something like this should be fine:
As for the pivot table I have never done one... Guess this is as good a time as any..
Good choice. I don't have XL 2000 to hand to check, but if memory serves me correctly Pivot Tables were introduced in XL 2000, so you are in luck.