hard20 pts · first answer countsexcelconditional-functions

SUMIF adds the wrong rows

Regions are in A2:A100 and amounts in B2:B100. What does this formula actually add up?

A.Exactly the North amounts, as ranges alignB.Nothing, it returns a #VALUE! errorC.The amount one row below each North rowD.Every amount in B3:B101, ignoring criteria

Discussion 0

Join free to post in the discussion.

SUMIF adds the wrong rows

Discussion 0

Related questions