spreadsheet help

[Vito Casa]

Good day, I have created a spreadsheet, with two sheets. The first sheet has a monthly calendar with employee's names. On the second sheet, I have a master schedule with all my employees and tasks assigned to them. On sheet 1, i can see the first month tasks and everything looks good. The problem i have is when i change the month. the Calander will update, but not the task. How can i get the tasks on month two, three and so on to show on sheet one?

 

[ETAF]

A SMALL sample spreadsheet, around 10-20 rows, would help a lot here, with all sensitive data removed, and expected results mocked up and manually entered, with a few notes of explanation.

This will possibly enable a quicker and more accurate solution for you.

 

[Vito Casa]

 

[pecoflyer]

Please attach your sheet, not a picture which cannot be worked with. Thx

 

[Vito Casa]

Here you go

 

[Vito Casa]

Have you had a chance to look at it?

 

[ETAF]

you have 4 sheets , so not sure what you are trying to do exactly - sorry - probably unable to help
but what version of excel are you using

 

[Vito Casa]

My apologies, i have deleted a couple of sheets. There is now the master and the schedule. I'm using Microsoft 365. I can call you to discuss the sheet.

 

[vletm]

Vito Casa​

I offer minor modifications ...

 

[Vito Casa]

This is perfect!

Thank you very much for your assistance

 

[Vito Casa]

Thank you, again. I was wondering if you can help me with another issue. On sheet1, I have it doing a task count for the month. Is there a way to change the month and have the formula do a task count?

 

[vletm]

Vito Casa​

#1 One thread per thread - open a new thread for Your new wondering.
#2 Why You won't use same month that You've used with Schedule-sheet?
#3 Check Countifs-function.

 

[Vito Casa]

I'm fairly new to formulas. I wouldn't know how to do that

 

[vletm]

If You step #1 then study eg from those

COUNTIFS function - Microsoft Support

How to use the COUNTIFS function in Excel to apply criteria to cells, across multiple ranges, and count the number of times all criteria are met.

support.microsoft.com

COUNTIFS Function

The Excel COUNTIFS function returns the count of cells in a range that meet one or more conditions. Each condition is provided with a separate range and criteria, and all conditions must be TRUE for a cell to be included in the count. COUNTIF can be used to count cells that contain dates...

exceljet.net

MS Excel: How to use the COUNTIFS Function (WS)

This Excel tutorial explains how to use the Excel COUNTIFS function with syntax and examples. The Microsoft Excel COUNTIFS function counts the number of cells in a range, that meets a single or multiple criteria.

www.techonthenet.com