Vlookup Question

[jimmybangs]

Hi,

I have a quick question surrounding vLookups and wondered if anyone can help. I need a vlookup that will tally the total of the lookup value from a seperate sheet.

<a href="http://www.flickr.com/photos/67298551@N07/6169686262/" title="2011-09-21_1618 by digiteers, on Flickr"><img src="http://farm7.static.flickr.com/6175/6169686262_b64d134c78.jpg" width="500" height="206" alt="2011-09-21_1618"></a>

e.g. for the above if B6 = 21/09/2011 the Vlookup function will tally up the sum of all of the figures that are associated with the same date within the table...any ideas?

I've tried to use IF functions but can't get it to work.

Cheers,
James

 

[T. Valko]

Hi,

I have a quick question surrounding vLookups and wondered if anyone can help. I need a vlookup that will tally the total of the lookup value from a seperate sheet.



e.g. for the above if B6 = 21/09/2011 the Vlookup function will tally up the sum of all of the figures that are associated with the same date within the table...any ideas?

I've tried to use IF functions but can't get it to work.

Cheers,
James

Use the SUMIF function.

=SUMIF(F6:F20,B6,G6:G20)

 

[njimack]

=sumif(f6:f17,b6,g6:g17)

 

[jimmybangs]

Sweet! Cheers