Hi! I have a question about a formula in Calc. I hope there is someone who can help me... Here it goes.
I have a table where collumn B is storing dates and collumn C is storing money values referring to those dates. In another table, I would like to sum the money values for each week. I have been trying to accomplish this by creating a table with collumn with the initial day of each week (for the collum named "Week") and using the function COUNTIF. However, I am not able to specify two conditions or criteria for that function. Is there any way to say Calc to sum something in different cells if a DATE value is between X and Y?
Thanks in advance, Victor Domingos http://lojamac.com/blog
