babaso_tawase
Board Regular
- Joined
- Feb 5, 2017
- Messages
- 65
- Office Version
- 2007
- Platform
- Windows
Hi Every one,
I want your help regarding conditional sum.
I am using EXCEL 2003, that don't have SUMIFS function.
I have data as
Column A= number of sample
Column B= Status C=complete, P=pending
Column C =Date
<tbody>
</tbody>
<tbody>
</tbody>I want formula to calculate from certain period of date , number of sample completed and number sample pending.
I AM USING THIS FORMULA BUT NOT WORKING
FOR PENDING SAMPLE =SUMPRODUCT((B2:B7=B10)*(E10<=C2:C7<=E11)*A2:A7)
FOR COMPLETED SAMPLE =SUMPRODUCT((B2:B7=B11)*(E10<=C2:C7<=E11)*A2:A7)
Thanks EVERY ONE...
I want your help regarding conditional sum.
I am using EXCEL 2003, that don't have SUMIFS function.
I have data as
Column A= number of sample
Column B= Status C=complete, P=pending
Column C =Date
A | B | C | |
1 | No. of sample | Status | Date |
2 | 10 | P | 20/12/17 |
3 | 11 | P | 21/12/17 |
4 | 5 | C | 20/12/17 |
5 | 8 | C | 22/12/17 |
6 | 3 | P | 23/12/17 |
7 | 5 | C | 27/12/17 |
<tbody>
</tbody>
<tbody> </tbody> |
<tbody>
</tbody>
I AM USING THIS FORMULA BUT NOT WORKING
FOR PENDING SAMPLE =SUMPRODUCT((B2:B7=B10)*(E10<=C2:C7<=E11)*A2:A7)
FOR COMPLETED SAMPLE =SUMPRODUCT((B2:B7=B11)*(E10<=C2:C7<=E11)*A2:A7)
Thanks EVERY ONE...