Adding Values In A Column

[Karleajensar]

In column -K- I have a list of dollar values. In column -S- an "X" may be in those cells. How do I add the values in column -K- that have an "X" in the corrosponding cell from the -S- column?

Thank you for your help.

[gregvb]

=sumproduct((s2:s1000="X")*(K2:k1000))


just modify your ranges to where the formula starts looking at the first line of your entries

[Karleajensar]

Thanks you!