I am looking to do a sum of a bunch of data. I will do my best to lay out the file and what I am looking for.
I have a sheet (line 1) with every day of the year in column B
Also on that sheet, I have a 1 or a zero in column K
On a different sheet (test), I have random dates (dates something took place)
<colgroup><col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;">
<col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;">
<col width="64" style="width: 48pt;" span="9">
<tbody>
</tbody>
<colgroup><col width="78" style="width: 59pt; mso-width-source: userset; mso-width-alt: 2852;">
<col width="57" style="width: 43pt; mso-width-source: userset; mso-width-alt: 2084;">
<col width="64" style="width: 48pt;" span="9">
<tbody>
</tbody>No for the index beyond me. On a different sheet, where the equation will go, I am looking for an index that says if column K in sheet (line 1) =1 find test before that date and multiply by the factor * .58 + another factor that is not going to change * 0.42 and do that for the entire year and sum them up. there are about 16 times K will = 1 Any help would be great.
thanks
I have a sheet (line 1) with every day of the year in column B
Also on that sheet, I have a 1 or a zero in column K
On a different sheet (test), I have random dates (dates something took place)
Date | CO (lb/hr) | NOX (Shutdown only) (lb/hr) | PMfilt (lb/hr) | PM10 (lb/hr) | PM2.5 (lb/hr) | SO2 (lb/hr) | VOC (lb/hr) | Acrylonitrile (lb/hr) | HCN (lb/hr) | NH3 (lb/hr) |
4/1/2018 | 0.6 | 1.1 | 3.7 | 3.7 | 0.42 | 0.4 | 0.99 | 0.68 | ||
5/23/2018 | 0.6 | 0.35 | 3.7 | 3.7 | 0.42 | 0.6 | 0.0018 | 0.61 | 0.66 | |
7/18/2018 | 0.6 | 0.4 | 2.7 | 2.7 | 0.42 | 0.6 | 0.0038 | 0.61 | 0.66 |
thanks