Hello everyone,
I have data consists of dates and values. Dates start from column A1 to A9. Values start from B1 to B9. They are as follows:
Dates Values
<colgroup><col><col></colgroup><tbody>
</tbody>
The formula I'm using is: SUMIFS(B1:B9,A1:A9,A1,A1:A9,A7)
This formula returns zero value. Any suggestions?
Many thanks,
Marwan
I have data consists of dates and values. Dates start from column A1 to A9. Values start from B1 to B9. They are as follows:
Dates Values
01/01/2013 | 5,200 |
02/01/2013 | 2,500 |
03/01/2013 | 7,846 |
04/01/2013 | 444 |
05/01/2013 | 5,852 |
06/01/2013 | 441 |
07/01/2013 | 696 |
08/01/2013 | 332 |
09/01/2013 | 114 |
<colgroup><col><col></colgroup><tbody>
</tbody>
The formula I'm using is: SUMIFS(B1:B9,A1:A9,A1,A1:A9,A7)
This formula returns zero value. Any suggestions?
Many thanks,
Marwan