View Single Post
  #7   Report Post  
 
Posts: n/a
Default find instances & report neighboring values

All I am getting is a zero. It could very well be that I just am not
following very well, however.

Here is an example from my sheet:

items from 'd'

Oct-05
Oct-05
Oct-05
Nov-05
Jan-06

their corresponding values from 'e'

$35
$10
$10
$3
$7

In this example, Oct-05 total = $55, Nov-05 = $3, and Jan-06 = $7

I think you have what I am saying (but am including the example just
incase) but I may not be following what you are saying. When I copy /
paste the equation you gave above, I only got a '0'. Is there something
that I should be changing in the equation (other than ranges as I don't
need 1000 cells worth) that I may have missed?

Thanks so very much and I am very sorry to trouble you with such a
novice issue.