okt 2007
Added a lesson with =SUMIF() -- how to sum only lines meeting certain criterias
14/10/07 19:51 Filed in: Calc
Just added a lesson with the formula =SUMIF(), which is used for summing lines meeting the criteria you specify. This works kinda like =SUM(), but with a powerful twist.
This is a medium difficult formula, but is very powerful.
Click here for the RSS feed.
![](page5_blog_entry21_1.png)
This is a medium difficult formula, but is very powerful.
Click here for the RSS feed.
![](page5_blog_entry21_1.png)
|
Added a lesson with =TRUNC() -- how to cut off decimals
10/10/07 19:59 Filed in: Calc
Just added a lesson with the formula =TRUNC(), which is used for cutting off decimals.
And, further good news; this is also one of the easier formulas![Happy](../../rw_common/plugins/blog/smiley_smile.png)
Click here for the RSS feed.
![](page5_blog_entry19_1.png)
And, further good news; this is also one of the easier formulas
![Happy](../../rw_common/plugins/blog/smiley_smile.png)
Click here for the RSS feed.
![](page5_blog_entry19_1.png)
Added a lesson with =ROUND() -- how to round values
07/10/07 20:26 Filed in: Calc
Just added a lesson with the formula =ROUND(), which is used for rounding values.
This is also one of the easier values.
Click here for the RSS feed.
![](page5_blog_entry18_1.png)
This is also one of the easier values.
Click here for the RSS feed.
![](page5_blog_entry18_1.png)