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 . I'm always getting an error when I used countifs and sumproduct and not sure how to proceed.
The Attached spreasheet is just a sample but it will be a database that I need to do.
This is the formula I'm trying to use but getting error
=countifs(K1:K4, A2, F1:F4, B1,J1:J4 <=B4, J1:J4>=B5)
Thank you for anyone who will answer this.
Bookmarks