In this section we used a formula called a conditional formula. It displays a message if the condition is true, finds the average of the worksheet values that meet one criterion and find the sum of worksheet values that meet two criteria.
first you type the required criteria into the formula bar or the cell you want.
then you click and drag the formula down to the other cells.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment