Computer Science, asked by Sankalpparab1740, 4 months ago

Hpw to compute the function for finding total mark in excel

Answers

Answered by s3625

0

Answer: Calculate marks with criteria in Excel

{ = SUM ( (response = correct_list) + 0) }
= SUMPRODUCT ( (response = correct_list) + 0)
{ = SUM ( ( key = range ) + 0 ) }

= COUNTBLANK ( range)
= SUMPRODUCT ( ( key <> range ) + 0 ) - COUNTBLANK (range)

Previous Question

Next Question

Similar questions

Accountancy, 1 month ago

what ia an economic event...

Math, 1 month ago

Find arithmetic mean from the following data Class interval: 60-69. 50-59. 40-49. 30-39. 20-29. 10-19. 0-9 Frequency: 2. 5. 8. 12. 9. 6. 4...

Math, 1 month ago

x Race of 2+÷x+2 is a quardiater polymional true false...

Science, 4 months ago

Soil, water, air which is a living thing and non living things...

Physics, 4 months ago

a simple pendulum makes 60 oscillations in 40 seconds calculate frequency an time period...

English, 10 months ago

punctuate the sentance they said we shall play...

Math, 10 months ago

iii. Solve this simultaneous linear equation by Cross Multiplication 20u – 30v = 13, 10v – 10u = -5...

Chemistry, 10 months ago

a closely wound flat circular coil of 25 turns of wire has diameter of 10cm and carries a current of 4ampere. Determined the magnetic field at the center of the coil.