Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 70
Default Summarize in Vlookup

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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default Summarize in Vlookup

Take a look SUMIF function in help menu


"Calle" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 70
Default Summarize in Vlookup

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

"Teethless mama" wrote:

Take a look SUMIF function in help menu


"Calle" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Summarize in Vlookup

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

On May 22, 7:14*pm, Calle wrote:
txs - could you give an example of the full formula!!



"Teethless mama" wrote:
Take a look SUMIF function in help menu


"Calle" wrote:


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- Hide quoted text -


- Show quoted text -


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cant summarize nrs like 15.200,00 Sircantona Excel Discussion (Misc queries) 3 April 29th 08 05:59 PM
summarize PBark New Users to Excel 3 April 11th 06 04:59 PM
Summarize Data kgsggilbert Excel Discussion (Misc queries) 1 June 8th 05 09:41 PM
Summarize Data Set Jim Excel Worksheet Functions 6 April 7th 05 03:46 PM
Summarize a column Zadig Galbaras Excel Discussion (Misc queries) 1 February 7th 05 06:00 PM


All times are GMT +1. The time now is 11:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"