mrkris1982
Active Member
- Joined
- Apr 16, 2009
- Messages
- 407
I have a chart that is populated, collecting data from each month of 2017 and I'd like to reuse this for 2018, but need to modify to cut down on the work.
<tbody>
</tbody>
In another section, I am doing calculations for monthly totals per app, pulling from the chart above
<tbody>
</tbody>
for the xxxxxxxxxx I need help
In my real spreadsheet, its doing a sum
where Q would equal the Chart 1 > Expected Uptime column above
Id like to leave the equation exactly as it is BUT only include it in the calculation of xxxxxxxxxx if there is an x in the adjacent column A cell
This would allow me to keep the chart in tact with the calculation only caring about the expected uptime for that app if there is an x in that apps column A cell for that month.
Hard to explain, but I am willing to give anything a try if someone wants to take a crack at it.
App | Month |
<tbody> </tbody> | Downtime | Total Uptime | ||
x | App1 | Jan | 737:15:00 | 10:00:00 | 727:15:00 | |
x | App2 | Jan | 744:00:00 | 4:44:00 | 740:00:00 | |
App1 | Feb |
<tbody> </tbody> | 5:00:00 | 460:00:00 | ||
App2 | Feb |
<tbody> </tbody> | 8:00:00 | 550:00:00 | ||
App3 | Feb |
<tbody> </tbody> | 1:00:00 | 650:00:00 |
<tbody>
</tbody>
In another section, I am doing calculations for monthly totals per app, pulling from the chart above
Month | App 1 Total Uptime | App 2 Total Uptime |
Jan | 727:15:00 | 740:00:00 |
Feb | 460:00:00 | 550:00:00 |
March | 465:00:00 | 548:00:00 |
Actual uptime total | =SUM(D2:D13) | |
Expected Uptime Total | xxxxxxxxxxxx | |
Percentage Up | =B5/B6 |
<tbody>
</tbody>
for the xxxxxxxxxx I need help
In my real spreadsheet, its doing a sum
Code:
=SUM(Q3+Q21+Q39+Q57+Q75+Q93+Q111+Q129+Q147+Q165+Q183+Q201)
Id like to leave the equation exactly as it is BUT only include it in the calculation of xxxxxxxxxx if there is an x in the adjacent column A cell
This would allow me to keep the chart in tact with the calculation only caring about the expected uptime for that app if there is an x in that apps column A cell for that month.
Hard to explain, but I am willing to give anything a try if someone wants to take a crack at it.
Last edited: