i have tried a few formulas and wasnt getting exactly what i need
I am wanting a result (a number) in F2 of how many of each animal (B2:B31) was taken from each section (D2:D31).
i have tried a few formulas and wasnt getting exactly what i need
I am wanting a result (a number) in F2 of how many of each animal (B2:B31) was taken from each section (D2:D31).
In F2:
Does that do it?Please Login or Register to view this content.
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
No, i plugged that formula into F2 and visually checked/counted more than the result the formula gave for animals in that particular section
i got this to work to some extent
=COUNTIFS(B2:B31,J3,D2:D31,J5) dependent on the selection of two dropdown boxes i added
Last edited by kelmaur; 02-14-2018 at 07:04 PM.
Then is your problem [Solved] ?
yes it has been SOLVED.
Thanks for the help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks