I am having a hard time creating an if statement that lets me total up the items within a column. Here is my data:
SPREADSHEET TAB #1
Task Estimate (in minutes Due Today? Project
XYZ 15 Yes 2
ABC 30 No 1
123 60 Yes 2
Here is where I am having the problem. In a second tab, I want to add up the total estimate (in minutes) if an item is due today based on the project. So if Project #2 has 3 tasks due that day, I want it to add up those 3 tasks that are due and give me the total time I estimated. So from the example above, project #2 has two tasks Due Today for a total of 75 minutes.
Here is how the second spreadsheet is set-up
SPREADHSEET TAB #2
Project Total Due Today (in minutes)
1 <FORMULA TO AUTOMATICALLY SUM HERE>
2 <FORMULA TO AUTOMATICALLY SUM HERE>
I have done a number of IF tasks, but it won't let me search an entire column for a "Yes" in due today, it wants to make me go cell by cell, put it in a seperate spreadsheet and do it that way, but there has to be a better more efficient way. Thanks for your help
SPREADSHEET TAB #1
Task Estimate (in minutes Due Today? Project
XYZ 15 Yes 2
ABC 30 No 1
123 60 Yes 2
Here is where I am having the problem. In a second tab, I want to add up the total estimate (in minutes) if an item is due today based on the project. So if Project #2 has 3 tasks due that day, I want it to add up those 3 tasks that are due and give me the total time I estimated. So from the example above, project #2 has two tasks Due Today for a total of 75 minutes.
Here is how the second spreadsheet is set-up
SPREADHSEET TAB #2
Project Total Due Today (in minutes)
1 <FORMULA TO AUTOMATICALLY SUM HERE>
2 <FORMULA TO AUTOMATICALLY SUM HERE>
I have done a number of IF tasks, but it won't let me search an entire column for a "Yes" in due today, it wants to make me go cell by cell, put it in a seperate spreadsheet and do it that way, but there has to be a better more efficient way. Thanks for your help