Zylock
New Member
- Joined
- Jul 8, 2022
- Messages
- 4
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2007
- Platform
- Windows
- Mobile
- Web
Hello! First time posting for help with excel formula. I've so far been successful at finding solutions to my relatively simple problems. This is the first task that I need help with!
What I'm trying to do is:
- Look into a cell to see if the DATE stored there is within a certain range
- THEN look into a different cell to see if the data there is one of a small list of predefined values
- THEN, if the second cell contains the right data, look into another cell to pull a number
- Finally, I want to SUM all of the successful outputs into a final, separate cell.
I'm using a spreadsheet to track pipe inspections. Each pipe is a certain length (in meters), but is only considered complete when there is an inspection done from both ends. I need to tally the total meters of each week's successfully completed pipe inspections. So far I have all of the input columns set up and correctly configured with data validation. The two columns that track if an inspection has been done from each end of the pipe have the preset values "Yes," "Needed," "Impossible," and "See Comments." For the purposes of a complete inspection, only "Yes" and "Impossible" would be considered sufficient for completion. The date column is set up to contain only dates input by the date-selection field. And there is a column containing the total number of meters for the pipe segment.
My inexperienced Excel brain has started to conceive of IF statements here and there, but I cannot even begin to see how to accomplish what I need.
Any and all help is deeply appreciated!
What I'm trying to do is:
- Look into a cell to see if the DATE stored there is within a certain range
- THEN look into a different cell to see if the data there is one of a small list of predefined values
- THEN, if the second cell contains the right data, look into another cell to pull a number
- Finally, I want to SUM all of the successful outputs into a final, separate cell.
I'm using a spreadsheet to track pipe inspections. Each pipe is a certain length (in meters), but is only considered complete when there is an inspection done from both ends. I need to tally the total meters of each week's successfully completed pipe inspections. So far I have all of the input columns set up and correctly configured with data validation. The two columns that track if an inspection has been done from each end of the pipe have the preset values "Yes," "Needed," "Impossible," and "See Comments." For the purposes of a complete inspection, only "Yes" and "Impossible" would be considered sufficient for completion. The date column is set up to contain only dates input by the date-selection field. And there is a column containing the total number of meters for the pipe segment.
My inexperienced Excel brain has started to conceive of IF statements here and there, but I cannot even begin to see how to accomplish what I need.
Any and all help is deeply appreciated!