Ok so, looking at the below image; I would like to be able to count the total number of fish hooked (column B)from a certain location (column E) and count that in the small table on the right side. I can not figure out how to do this. Any insight would be great!
excel_zps90gkggpf.png
Last edited by treyk; 10-03-2016 at 03:19 PM.
SUMIF(e6:e100,H18, b6:b100)
rather than the image - attach the spreadsheet
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Awesome! Thank you Wayne.
you are welcome
thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks