Fragen ID: 1542 12/34
PREVIOUS QUESTION NEXT QUESTION

Insert the appropriate function in the cell A1 to sum up values greater than or equal to 5000 in the cell range A2:A100.
Insert the appropriate function in the cell B1 to sum up the cells, the corresponding cells of which in column A display a value greater than or equal to 5000, in the cell range B2:B100.

 

 

Other versions
Microsoft Excel 2003Microsoft Excel 2007Microsoft Excel 2010Microsoft Excel 2013Microsoft Excel 2016Microsoft Excel 365

 

 

 


Insert the appropriate function in the cell A1 to sum up values greater than or equal to 5000 in the cell range A2:A100.
Insert the appropriate function in the cell B1 to sum up the cells, the corresponding cells of which in column A display a value greater than or equal to 5000, in the cell range B2:B100.