May 06 2022 07:51 AM
Hello all,
I have been using Google Sheets and never had any issues. However, our school is transferring over to all things OneDrive, so I'm trying to set up a spreadsheet similar to one I had in Google Drive. The formula was copied from the Sheets I had, but it did not work with my current Microsoft Excel spreadsheet for whatever reason. Any help is appreciated.
I wanted to gather how much the student and staff workers got paid in certain pay periods on a different tab, but the formula is not working for me.
Here is what I had with Google Drive with the first tab (had to erase personal informations) with a long list of student and staff names:
Tab 2 that is being used to reflect tab 1.
And this is the Microsoft Excel. Although to be fair, I have changed up the style and fields a bit, but that should not impact the formula as much as I have edited it to reflect the new cells, but it still does not work. I tried inputting some hours to see if any changes would come up in the second tab, but nothing happens.
Please let me know if the formulas needs to be changed a bit. Thanks!
May 06 2022 08:05 AM
SolutionMay 06 2022 08:13 AM
May 06 2022 08:05 AM
Solution