SUM PRODUCT Function

  • Thread starter Thread starter Jhova5
  • Start date Start date
J

Jhova5

I have an excel sheet regarding the major league baseball draft for the
past five years. I have several variables(draft round, position,
schooling, level reached, etc). It works well for most of my
sumproduct searches. When I try to find out how many people reached
the major leagues within some of the variables, it never counts them
the right way. It will count maybe 5 when there are probably 25-30 who
reached this level. How can I ensure that it counts the criteria for
the sumproduct searches correctly?
 
Jhova,

It may be that some of the criteria cells are text, and others numbers. To
determine that, deselect any of the four horizontal alignment buttons (left,
center, right, justify). Numbers should all be right-justified now. If
text, they'll be left.

Or it may be that you've inadvertently set it to give you a count instead of
a sum. Give us your formula, and some example data.
 
Back
Top