Forum Discussion
Solved
Function IF then SUM of the values newly attributed?
Hi ! So I'm an excel newbie and I'm trying to create a formula to help with the scoring of a questionnaire. Basically people attribute values from 1-6 to the questions and I need a formula th...
Let's say the scores from 1 to 6 are in D2:D100.
The number of 4's in this range is
=COUNTIF(D2:D100, 4)
No helper cells with IF formulas needed.
Let's say the scores from 1 to 6 are in D2:D100.
The number of 4's in this range is
=COUNTIF(D2:D100, 4)
No helper cells with IF formulas needed.
Oh right, that's much easier than what I was doing ! Thank you very much for your help.