Homework answers / question archive / The following COUNTIF function was entered into a cell on an Excel worksheet and will be copied and pasted to other cell locations: =COUNTIF(Detail!A2:A10, Summary!A5) Which of the following is a flaw with this function? The criteria argument must be defined with more than one cell reference and is typically defined with a contiguous cell range

The following COUNTIF function was entered into a cell on an Excel worksheet and will be copied and pasted to other cell locations: =COUNTIF(Detail!A2:A10, Summary!A5) Which of the following is a flaw with this function? The criteria argument must be defined with more than one cell reference and is typically defined with a contiguous cell range

Accounting

Share With

The following COUNTIF function was entered into a cell on an Excel worksheet and will be copied and pasted to other cell locations: =COUNTIF(Detail!A2:A10, Summary!A5) Which of the following is a flaw with this function? The criteria argument must be defined with more than one cell reference and is typically defined with a contiguous cell range. The range argument can only be defined with a single cell location, number, or text enclosed in quotations. An absolute reference should be placed on both cell range A2:A10 and the cell reference A5. An absolute reference should be placed on the cell range A2:A10. The words Detail and Summary must be enclosed in quotations,