Let's say I have this condition:
| Col A | Col B
10 |Jan 1 2017 | €15.0
11 |Jan 2 2017 | €17.0
12 |Jan 3 2017 | €11.0
...| ... | ...
186|June 26 2017 | € 23.55
In cell B1 I would like the sum of the money from a certain date to another So, let's say, I would like to know the sum during April. What I know about the IF statement is something like this IF($A:SA<=;true;false) but this will give me 0 because it will refear to A1 instead of all column A. I don't know if I was clear enough but, if someone got it, could give me some help? Thanks
Aucun commentaire:
Enregistrer un commentaire