LinkBack URL
About LinkBacks
I need a formula (see attached) in column I that returns the number of times the text in "Sheet 2" is used.
I need a formula (see attached) in column I that returns the number of times the text in "Sheet 2" is used.
Last edited by HeleneDelgado; 06-14-2017 at 10:36 AM. Reason: Added attachment
Attachment ?
The paper clip icon does not work.
I just attached the file.
Thanks...Helene
Enter in I7 and copy down
Formula:
=COUNTIF(Sheet2!A:A,B7)
or if you also want to include Date parameters
Formula:=COUNTIFS(Sheet2!A:A,B7,Sheet2!C:C,">="&C$1,Sheet2!C:C,"<="&C$2)
Last edited by AlKey; 06-14-2017 at 11:04 AM.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
I have part 2 of the equation...
I have workbook with two tabs. Every download has a different author. I need to know how many unique users downloaded the content. The formula could be anywhere.
The destination sheet is Sheet1. The source data is Sheet1, column D.
Due to the size or your data, for the unique users part you should use Pivot table.
Please see attached.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks