Added a lesson with =SUMIF() -- how to sum only lines meeting certain criterias

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.
|

Added a lesson with =TRUNC() -- how to cut off decimals

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

Click here for the RSS feed.
|

Added a lesson with =ROUND() -- how to round values

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.
|