View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_4_] Gary Keramidas[_4_] is offline
external usenet poster
 
Posts: 226
Default 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