I'm working on a formula and not sure what I'm doing wrong.
My current formula that works is:
=IF(OR(M19="YES",M19="NO"),SUM(B13:B18)-SUM(B19:B94),0)

I want the formula to encompass M19:M94, but when I do that, it doesn't work correctly - it just gives me the same figure for all "". Any idea how to do this??

Does your PhD define your research for your career?

Anyone has an alternative to an Au Pair. Wife and I were looking forward to host an au pair but can’t go through the official program since we are not permanent residents yet. Anyone has an alternative besides traditional daycare? Maybe a friend of a friend? I am in NJ. Any ideas welcomed and needed!

I joined pwc india recently with IFS, but wanted to join PwC IAC IFS.

Can. Someone plz refer me. I don't want to waste my time initial phase of career. Please help me out.

Thanks in advance.

Hello Fishes,
I am much stressed.. it’s only been 5 months to join Capgemini. I joined in as cyber security consultant with good package.
However, the work I do the tricks, logics and solutions I share with team to apply in the project… all are of no use when discussed with the architect guy. The whole team rely upon the wordings/solutions suggested by him only. It feels like my skill/knowledge and experience is of no use.
I feel like what am I doing here….? Any suggestions please.

Could anyone please tell about NPS CCD(2) ? Is it paid by employer? What needs to be done in this?

Long-time hodler (btc, eth only) feeling scared for the future of crypto as more info comes out about tether and bitfinex. Help!

To all those who have got or trying to get international assignments. What skills do we need to showcase to our leads/managers and possess.
Also those who are managers what do you expect one should have in order to get this opportunity.
Please don't say bootlicking/politics/favouritism etc. Those might be there but what are real skills.
Please throw some light on this folks !!

Guys how much is expected pay in Capgemini for BI consultant Role for 8yrs exp..n how is Job Security n work culture with Onsite opportunities in Capgemini?

I am joining Deloitte India next week and I have received a mail from the recruitment team that I have assigned with a "Buddy" from Deloitte to help me guide through the beginning.

Is this a normal thing in Deloitte/Big4? What is the significance?

Hoping to get my PHR in the next year or so. Outside of employer reimbursement, are there other opportunities for this to get funded? I know SHRM Foundation offers scholarships for the CP, but I am looking for PHR specific help. Thank you! :)

Which is the best company for salesforce developer and onsite opportunities?
EPAM or Naggaro

Hi Fishes
I am having 3.5 yrs of experience in production support background.
Having knowledge on contact center technology products like verint impact 360,verint v15.1,Avaya
Call Monitoring
Troubleshooting
Ticket management
Change management
Log analysis
Health checks
Etc..
Currently serving notice period can join in 30 days LWD Feb 16th
I am interested to learn new technologies as well
Please do refer me if any opportunities

Thanks in advance

Is laptop reimbursement policy still available or not since hybrid wfo has resumed? Joined last month. This is for Mumbai

Has anyone had any issues getting a response back from pathways. They are not responding to my emails when I ask for assistance.

Anyone wanna rant? If so, please provide details of the craziest shit u have been through in ur career🤗

How to look about for opportunities for Acca candidate who has 3y experience in external audit ? Looking for suggestions ! Thanks

How are you doing MN crew?

Hi All, Any update on CTS work from home extension?

Has anyone ever worked at Bryant Miller Olive? Looking for some insight

Still don't have xlookup. #fomo

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

How do I compare two sheets to make sure they are identical?

Anybody have the SQL server data mining add in on excel? Desperately need to run a really quick analysis through it but can’t configure it.

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Hey guys, I'm trying to find a formula to use instead of the Goal Seek function. Anyone know it? I thought I had seen one years ago, but can't find it now.

Would anyone be willing to teach me vlookup?

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

What are some common reasons that a COUNTIF formula might not be working correctly? I'm using the correct range and value to count. I'm not seeing "ERROR" but the values aren't correct (it's not counting everything). Thx.

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

Hi Group, seems like it should be basic format, but I just can not get it to work. a list of data and want to alternate shade (blue,white,blue,etc) each line but if I have multiple lines I want to group together and they all shade the same. I want to group by the same data in column A, and the number of rows that are the same could vary. So let’s say row 1& 2 same entry in column A(blue) row 3 different (white) row 4,5,6 same as each other different to other rows (blue) etc… help 🙏

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?