Recent content by LGordon

I managed to get September's spreadsheet to calculate correctly. Thanks for your help. It seems I'm always having one kind of problem or another with this spreadsheet so yes, that statement means I have a new problem. Each month I make adjustments to the classes. I add/delete rows to...

That was one of the changes I realized I needed to make (so proud of myself for seeing that in the formula). The column range needed to be extended to U as it had previously been R. I added 3 more columns thus I had to change all the references to R to U, which I did. Still not calculating...

Hi Shamimarita, As I began making the edits, I'm not sure just adding Saturday will work. The students are Saturday only students so those that are present the rest of the week will never attend on Saturday. My question to you is... what is the easier edit for me? Is it easier to add...

Hi Shamimarita, Thank YOU so much!!!! It took me awhile to find where I change the year but it was under "data validation." So simple. The years were in a list. I just had to list the years I wanted. Very simple! Thank you!!! I had a little bit more trouble figuring out the Saturday, but...

Hi Shamimarita, Thank you for your help on this spreadsheet. I am not that good at Excel. I'm a beginner. I can only do very simple formulas and reading through your explanation made perfect sense but when I tried to follow the directions, I just am too much of a beginner to do this...

I've run into a few issues with the spreadsheet that I just did a workaround for because I didn't have time to figure out what was wrong nor the ability ;) 1 - not an issue right now, but the last year on this is 2025. How do I adjust it for the future years? When created, it was created...

Thank you so much for your help. I knew it was something I wasn't doing correctly that would fix it. Again, this has helped me immensely. Thank you. Thank you. Lisa

Thank you for your help. Using the fixed spreadsheet that Shamimarita uploaded for me, I completed the June sheet. All the sheets worked great with the exception of the Grand Total sheet. It isn't calculating anything. I've uploaded my completed sheet. Maybe you can see what is wrong. I...

Dear Luftor Rahman Shimanto, Thank you so much! This has helped me. I'm having a problem with the formula for the Grand Total sheet - May 2024. Lines 7 and 8 which is May 2nd and 3rd is not calculating correctly. All of the other lines are correct.

Wow! This looks like it will work!!!! Thank you so much! Some months there are less students and others more students. How will adding and removing rows affect the formula? Right now the sheet has no actual names, but what if I put in their names and then sort them alphabetically, will the...

I'm using Excel in Microsoft 365. I am using Excel to keep track of 4 classes attendance/meal records. At the end of each month, I have to total the meals by free and paid. Each week, I have a total sheet and then the very last worksheet is a grand total of the meals for each day. I have...