Summarize in Vlookup

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Calle - 22 May 2008 11:48 GMT

Hi,
qucik question.
i have a data table and using vlookup. however getting stuck when i need to
summarize all values that matches my vlookup ref. Any help, suggestion would
be great.
Cheers

Reply to this Message

Teethless mama - 22 May 2008 12:36 GMT

Take a look SUMIF function in help menu

> Hi,
> qucik question.
> i have a data table and using vlookup. however getting stuck when i need to
> summarize all values that matches my vlookup ref. Any help, suggestion would
> be great.
> Cheers

Reply to this Message

Calle - 22 May 2008 19:14 GMT

txs - could you give an example of the full formula!!

> Take a look SUMIF function in help menu
>
[quoted text clipped - 4 lines]
> > be great.
> > Cheers

Reply to this Message

Pete_UK - 23 May 2008 01:21 GMT

You will need to give a few more details of what data you have, how it
is laid out, and what you intend to do with it. For example, what does
"summarize" mean to you?

Pete

> txs - could you give an example of the full formula!!
>
[quoted text clipped - 8 lines]
>
> - Show quoted text -

Reply to this Message