Hello all. I've been trying to use Sumif and Vlookup to solve this, but can't get it to work. (too many criteria, or too few). What I'm looking for is expenses entered to be sorted by department with multiple departments on one department tab (Rooms) and other expenses to calculate on the other department tab (F & B).
To get result, I've used sumifs() in the attachment...
Hope it helped you!!
Thanks, but not what I needed.
Purchases should be divided into departments with R,M, & H posting to Rooms Sales & Summary tab
and F posting to the F & B Sales and Summary tab.
Codes S and A should only be included in the Summary Tab
something like this
in C4 of rooms sales and summary copy paste below then drag down
Formula:
Please Login or Register to view this content.
in C4 of F&B sales and summary copy paste below then drag down
Formula:Please Login or Register to view this content.
in what sheet you want to match code A and S then you can use below at required place
Formula:Please Login or Register to view this content.
change the red part to match the date you want to be referenced
Last edited by hemesh; 02-28-2020 at 11:54 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks