Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search worksheets in same book to return value matching criteria?
What I need to do is match subscriber phone number from one column and return
total for that subscriber to adjacent column for that subscriber searching other worksheets in same book. What is the best function to use? Please be specific as my Macro/VB are almost non-existing. Main Worksheet: Column A Column B 972-222-1111 (Blank) Search Worksheets with Data for several accounts (ws_acct1, ws_acct2,etc..) Column A Column B 972-222-1111 $124.00 Main Worksheet: With Results Column A Column B 972-222-1111 $124.00 Pretty staight forward, but have not worked with these functions in years. Please help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search worksheets in same book to return value matching criteria?
Hi Jane,
You can use the Sumif for each range, and sum the sumif statements for all of the worksheets. Hope this helps. "Jane Doe" wrote: What I need to do is match subscriber phone number from one column and return total for that subscriber to adjacent column for that subscriber searching other worksheets in same book. What is the best function to use? Please be specific as my Macro/VB are almost non-existing. Main Worksheet: Column A Column B 972-222-1111 (Blank) Search Worksheets with Data for several accounts (ws_acct1, ws_acct2,etc..) Column A Column B 972-222-1111 $124.00 Main Worksheet: With Results Column A Column B 972-222-1111 $124.00 Pretty staight forward, but have not worked with these functions in years. Please help. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search worksheets in same book to return value matching criter
I'm sorry, I think I mislead you on what I need. I don't need a total of
several cells for each subscriber. I need to locate the subscriber (column A) in other worksheets and bring in the amount in column B to column B of Main worksheet. The main worksheet column A and column B are the same as other worksheets I need to search. Main worksheet column B is blank need to fill with amount that is located somewhere in the other worksheets. Hope this makes since. "pshepard" wrote: Hi Jane, You can use the Sumif for each range, and sum the sumif statements for all of the worksheets. Hope this helps. "Jane Doe" wrote: What I need to do is match subscriber phone number from one column and return total for that subscriber to adjacent column for that subscriber searching other worksheets in same book. What is the best function to use? Please be specific as my Macro/VB are almost non-existing. Main Worksheet: Column A Column B 972-222-1111 (Blank) Search Worksheets with Data for several accounts (ws_acct1, ws_acct2,etc..) Column A Column B 972-222-1111 $124.00 Main Worksheet: With Results Column A Column B 972-222-1111 $124.00 Pretty staight forward, but have not worked with these functions in years. Please help. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
search worksheets in same book to return value matching criter
Hi Jane,
=SUMIF(ws_acct1!A:A,"972-222-1111",ws_acct1!B:B)+SUMIF(ws_acct2!A:A,"972-222-1111",ws_acct2!B:B)+etc. Hope this helps. "Jane Doe" wrote: I'm sorry, I think I mislead you on what I need. I don't need a total of several cells for each subscriber. I need to locate the subscriber (column A) in other worksheets and bring in the amount in column B to column B of Main worksheet. The main worksheet column A and column B are the same as other worksheets I need to search. Main worksheet column B is blank need to fill with amount that is located somewhere in the other worksheets. Hope this makes since. "pshepard" wrote: Hi Jane, You can use the Sumif for each range, and sum the sumif statements for all of the worksheets. Hope this helps. "Jane Doe" wrote: What I need to do is match subscriber phone number from one column and return total for that subscriber to adjacent column for that subscriber searching other worksheets in same book. What is the best function to use? Please be specific as my Macro/VB are almost non-existing. Main Worksheet: Column A Column B 972-222-1111 (Blank) Search Worksheets with Data for several accounts (ws_acct1, ws_acct2,etc..) Column A Column B 972-222-1111 $124.00 Main Worksheet: With Results Column A Column B 972-222-1111 $124.00 Pretty staight forward, but have not worked with these functions in years. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for multiple criteria, and return yet another | Excel Worksheet Functions | |||
I want to use a link to return all data matching a criteria | Excel Worksheet Functions | |||
Sorting and Matching criteria across rows to return a result in the last cell | Excel Worksheet Functions | |||
matching two worksheets and return to different value | Excel Worksheet Functions | |||
Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions |