Hi,
I need to build a spreadsheet based on the submitted data of our lead source. Below is my problem:
I need to count how many times A2 appear on K:K based on Status in A:A between the date in B4 and B5 .
Attached is my example.
Thank you for anyone who will answer this.
Last edited by lati2008; 09-22-2021 at 03:48 PM. Reason: Solved
Please try in B2:
Formula:
Please Login or Register to view this content.
If this is not exactly what you are looking for then please attach a workbook - that's easier for us to work with than a picture.
Last edited by GeoffW283; 09-22-2021 at 03:39 PM.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Super helpful! Thank you. I already marked this as solved and add you reputation. Thank you very much.Originally Posted by GeoffW283
Please try in B2:
Formula:Please Login or Register to view this content.
If this is not exactly what you are looking for then please attach a workbook - that's easier for us to work with than a picture.
Glad I could help. Thanks for the feedback and rep!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks