formula help please
i know i've seen something like this, but i don't know if it's sum(if,
sumif, or sumproduct:
anyway
2 columns of numbers
i need to add up the 1st column, but if the number in the cell to the right
of it is greater than that number, i need to add that number instead.
1 0
2 0
3 5
4 0
12
should be the sum
thanks
--
Gary
|