Morning,
i have data in columns a and b in C i want to count where grant occurs anywhere in column a and it says North East in column b. thank you for your help
Morning,
i have data in columns a and b in C i want to count where grant occurs anywhere in column a and it says North East in column b. thank you for your help
with a pivot table.
see the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
... or with a formula
=COUNTIFS(A:A,"=*grant*",B:B,"=North East")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
=SUMPRODUCT(ISNUMBER(SEARCH("grant",A1:A21))*(B1:B21="North East"))
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Sorted, thank you all for your assistance
Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks