Hi!
I'm trying to create a tallied version of a log of quotes per employee for our company reports. I have the following formula which pulls the numbers I need and am trying to transfer things down by date but it doesn't seem to want to flash fill and update the way I want it to, and per employee, this could take quite a while if it needs to be done individually. This is an example of what I'm trying to do:
=COUNTIFS(A:A,"1/4",B:B,"*Employee Name*", D:D,"*Quote*")
=COUNTIFS(A:A,"1/5",B:B,"*Employee Name*", D:D,"*Quote*")
=COUNTIFS(A:A,"1/6",B:B,"*Employee Name*", D:D,"*Quote*")
Please let me know if there's something I can do to make this auto-fill. Any help would be greatly appreciated. Thanks!
David
Bookmarks