0
Still curious? Ask our experts.
Chat with our AI personalities
Maxine
Coach
TaigaAdd your answer:
Earn +20 pts
How to use a formula as criteria in sumif?
A short explanation of the question: Sometimes it is needed to use a formula as criteria instead of a given criteria. For example if you need to find the sum of numbers that are above or below the average in the range. For both COUNTIF and SUMIF formulas, the way to use another formula for criteria is the following (pretext: range of numbers is A1:A15): =countif(A1:A15;">"&average(A1:A15)) or =sumif(A1:A15;">"&average(A1:A15);A1:A15) And for the case that any number should be exactly the same as the average, use the "=" sign after the ">" or "<" sign.
How much cost for a carpet for a15 ft by 20 ft room at 2.99 a yard?
15 ft X 20 ft = 300 square feet (1 yard/3 feet) = 100 square yards/2.99 = $33.44
How much is a15 percent tip out of 16?
2.40
Which adds all of the numbers in a range of cellsprovides a convinient means to calculate a total?
=SUM(A1:A15) If this SUM formula is put into cell A16, then the numbers in the cells above (A1 to A15) will be shown in cell A16 as a total.
A jacket regularly sells for 36.40 It is on sale at a15 percent discount the sales tax rate is 8 percent What is the total price of the shirt on sale including tax?
$36.40 x 0.15= 5.4636.40- 5.46= 30.9430.94 x 1.08= 33.42$33.42
