Alex O
Active Member
- Joined
- Mar 16, 2009
- Messages
- 345
- Office Version
- 365
- Platform
- Windows
I'm using the formula below, which seems to work in some instances but not others!!!! Can someone take a look and tell if the formula is logical or not.
Thanks
=IF(Q4="",SUMIF($AC$4:$AC$37448,I4,$AE$4:$AE$37448),SUMPRODUCT(($AC$4:$AC$37448=I4)*($AB$4:$AB$37448>=Q4)*($AE$4:$AE37448)))
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 51px;"><col style="width: 71px;"><col style="width: 58px;"><col style="width: 75px;"><col style="width: 50px;"><col style="width: 60px;"><col style="width: 50px;"><col style="width: 60px;"><col style="width: 82px;"></colgroup><tbody>
</tbody>
Thanks
=IF(Q4="",SUMIF($AC$4:$AC$37448,I4,$AE$4:$AE$37448),SUMPRODUCT(($AC$4:$AC$37448=I4)*($AB$4:$AB$37448>=Q4)*($AE$4:$AE37448)))
AA | AB | AC | AD | AE | AF | AG | AH | AI | |
4 | 385546 | 2/28/2011 | 102056 | CHK | 200 | 26 | 200 | 54 | 146 |
5 | 387212 | 3/14/2011 | 102056 | CHK | 200 | 26 | 200 | 54 | 146 |
6 | 393966 | 4/25/2011 | 102056 | CHK | 200 | 26 | 200 | 54 | 146 |
7 | 403608 | 6/27/2011 | 102056 | CHK | 200 | 26 | 200 | 54 | 146 |
8 | 409150 | 7/29/2011 | 102056 | CHK | 200 | 26 | 200 | 54 | 146 |
9 | 413250 | 8/29/2011 | 102056 | CHK | 200 | 26 | 200 | 54 | 146 |
10 | 426877 | 11/28/2011 | 102056 | CHK | 100 | 8 | 100 | 27 | 73 |
11 | 431320 | 12/27/2011 | 102056 | CHK | 100 | 13 | 100 | 27 | 73 |
12 | 409483 | 8/2/2011 | 102535 | CHK | 174 | 0 | 174 | 30 | 144 |
13 | 384017 | 2/23/2011 | 103875 | CHK | 200 | 40 | 200 | 54 | 146 |
<colgroup><col style="width: 30px; font-weight: bold;"><col style="width: 51px;"><col style="width: 71px;"><col style="width: 58px;"><col style="width: 75px;"><col style="width: 50px;"><col style="width: 60px;"><col style="width: 50px;"><col style="width: 60px;"><col style="width: 82px;"></colgroup><tbody>
</tbody>