Hi Gurus
Stuck on this complicated formula (well for me at least)!
Looking to find a formula(s) for the attached section in orange (I've manually added answers)
C4 needs to count how many C3 (East) and B4 (Trains) found in database (I2:L10), for the month selected in B3
(preferably without using an array formula)
Thank you
Last edited by tbomdiggity; 03-15-2024 at 02:37 AM.
"East " in C3 has " " after. Delete then below formula should work.
C4, drag down and accross
Please Login or Register to view this content.
Quang PT
Cell C4 formula , Drag down and across
Formula:
Please Login or Register to view this content.
Re: Count two variables from a table, including a monthly drop down
excellent - thank you both bebo021999 & wk9128 !
tbomdiggity You're Welcome. Glad to help . Thank You for the feedback.
If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks