What analogy can you suggest?

S

shamilovcliserv12016-04-01 14:54:22

Programming

shamilovcliserv1, 2016-04-01 14:54:22

It is necessary that the 13th line does not add up to this cell N4. And it is added, despite the fact that before that it was written =IF($A$3:$A$101="February", as I understand it, this is a feature of sumif

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

R

res2001, 2016-04-01
@shamilovcliserv1

I'm sorry, but you have

=IF($A$3:$A$101="February"

nonsense is written.
The "=" operation compares only one value, in your formula Excel always takes only the first cell of the range and compares it with February, the rest are ignored.
Explain the meaning of the formula in N4, then I will help you make the correct formula.