| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count words in a date sheet
Hi,
Am using Excel 2007 and have a date sheet and a summery sheet, e.g. Date Sheet: A B 1 01/01/09 Apples 2 01/01/09 Oranges 3 02/01/09 Apples 4 02/01/09 Apples Summery Sheet: A B C 1 01/01/09 02/01/09 2 Apples =??? (1) =??? (2) 3 Oranges =??? (1) =??? (0) How can I make =??? work? Thx in Adv. Alex. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count words in a date sheet
Try this:
Entered on Summary sheet cell B2: =SUMPRODUCT(--(Sheet1!$A$1:$A$4=B$1),--(Sheet1!$B$1:$B$4=$A2)) Copy across then down as needed. -- Biff Microsoft Excel MVP "Help AUB" <Help wrote in message ... Hi, Am using Excel 2007 and have a date sheet and a summery sheet, e.g. Date Sheet: A B 1 01/01/09 Apples 2 01/01/09 Oranges 3 02/01/09 Apples 4 02/01/09 Apples Summery Sheet: A B C 1 01/01/09 02/01/09 2 Apples =??? (1) =??? (2) 3 Oranges =??? (1) =??? (0) How can I make =??? work? Thx in Adv. Alex. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count words in a date sheet
Thx m8, it works great.
"T. Valko" wrote: Try this: Entered on Summary sheet cell B2: =SUMPRODUCT(--(Sheet1!$A$1:$A$4=B$1),--(Sheet1!$B$1:$B$4=$A2)) Copy across then down as needed. -- Biff Microsoft Excel MVP "Help AUB" <Help wrote in message ... Hi, Am using Excel 2007 and have a date sheet and a summery sheet, e.g. Date Sheet: A B 1 01/01/09 Apples 2 01/01/09 Oranges 3 02/01/09 Apples 4 02/01/09 Apples Summery Sheet: A B C 1 01/01/09 02/01/09 2 Apples =??? (1) =??? (2) 3 Oranges =??? (1) =??? (0) How can I make =??? work? Thx in Adv. Alex. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count words in a date sheet
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Help A.U.B." wrote in message ... Thx m8, it works great. "T. Valko" wrote: Try this: Entered on Summary sheet cell B2: =SUMPRODUCT(--(Sheet1!$A$1:$A$4=B$1),--(Sheet1!$B$1:$B$4=$A2)) Copy across then down as needed. -- Biff Microsoft Excel MVP "Help AUB" <Help wrote in message ... Hi, Am using Excel 2007 and have a date sheet and a summery sheet, e.g. Date Sheet: A B 1 01/01/09 Apples 2 01/01/09 Oranges 3 02/01/09 Apples 4 02/01/09 Apples Summery Sheet: A B C 1 01/01/09 02/01/09 2 Apples =??? (1) =??? (2) 3 Oranges =??? (1) =??? (0) How can I make =??? work? Thx in Adv. Alex. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I count words on Excel book or sheet? | Excel Discussion (Misc queries) | |||
| Count words in spreadsheets | Excel Discussion (Misc queries) | |||
| Identify and count words | Excel Discussion (Misc queries) | |||
| Look up date on another sheet and do count of active cells (column | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
Linear Mode
