It’s painful having to monitor and manage three different Teams chats/profiles.
3 Likes
Morning everyone.
4 Likes
But why?
2 Likes
He has 2 ghost employees…
2 Likes
Morning people of the palace
Who can I borrow for 10mins to setup up forumals in Excel for me - I am failing epically
3 Likes
Sounds more like a spellcheck problem…
3 Likes
Dude my brain is running on adrenaline
=SUMIFS( ‘Occupancy 2.0’!$S$2:$S$101, ‘Occupancy 2.0’!$C$2:$C$101, Reporting!B13, ‘Occupancy 2.0’!$B$2:$B$101, Reporting!$B$11)
That makes no sense to me
SUMIFS is a funny beast.
First argument is the column where the things you want to add up lives, if the other conditions are met.
Then the arguments come in pairs - second argument is the column where the formula looks for its conditional check, and if the second argument matches the third, it’ll add whatever was in the first column to the total.
EDIT: In your case, it’ll add numbers from Occupancy 2.0’!$S$2:$S$101 where Occupancy 2.0’!$C$2:$C$101 equals Reporting!B13 and Occupancy 2.0’!$B$2:$B$101 equals Reporting!$B$11.
2 Likes
- first original email with company domain. eg. RIBCCS.com
- second with original email but as a “guest” to connect with those outside of our domain but within the broader company eg. RIBCCS.com Guest
- third the company is getting everyone over to single domain to alleviate this eg. RIB-Software.com
It’s just painful as I now have to use Teams app for the first with a secondary account to switch between. And then use another browser (as primary browser is signed in with previous info) to monitor the global account.
2 Likes
Ok see that is greek
I was given that formula and it just confuses me
Ok that sounds painful.
We just log in to meetings as guest users I guess.
Not a function I’ve needed yet. Used Index match a lot though. More reliable than Vlookup.
1 Like
Mean. Funny. But mean.
2 Likes
To add to @Avatar’s explanation…
I think part of your confusion stems from the fact that the values your SUMIFS is using are being pulled from two different sheets in your workbook: Occupancy 2.0 and Reporting.
Your first argument values are on the sheet called Occupancy 2.0 in column S from row 2 down to row 101.
The values in that range will get added IF:
- the values that are in column C of that same sheet equal the value of a cell on a different sheet in the same workbook: cell B13 on the Reporting sheet
AND IF:
- the values that are in column B on Occupancy 2.0 are also equal to the value that is in cell B11 on the Reporting sheet.
2 Likes
You word good about excel.
2 Likes
Had to take my wife to Karl Bremmer casualty, now I’m stuck with the boys, dishes and washing. So inconsiderate.
4 Likes
Anyone want to come keep me company at OR Tambo until 10pm tonight when my parents arrive?
I’ve got some hot sauce for sale
3 Likes
Oh no. Hope it’s nothing too hectic and that Mrs. Beo is home soon enough to unburden you. 
2 Likes
Not sure what’s going on, to be honest, our GP gave us a referral letter for casualty so that they could take her asap. Suffering with shortness of breath and general heaviness on her chest.
6 Likes
Geez, man,holding thumbs that it’s nothing serious and easily treatable!
3 Likes
Praying all will be okay. And as a fellow dad I can say you got this man 
3 Likes