| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
COUNT
I need help in sorting out this problem:
count Certain type of Text Value in A:A only if the Date in B:B is after 2009-01-01 A B box 2008-01-02 cat 2009-02-02 box 2009-03-03 cat 2008-12-15 fox 2009-03-05 -- Toronto |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
Try this:
=SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1)) This assumes the text string you're looking for is stored in C1 and the date you want to compare against is stored in D1. HTH Elkar "observer" wrote: I need help in sorting out this problem: count Certain type of Text Value in A:A only if the Date in B:B is after 2009-01-01 A B box 2008-01-02 cat 2009-02-02 box 2009-03-03 cat 2008-12-15 fox 2009-03-05 -- Toronto |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
COUNT
Thank you so much Elkar. Your solutions is simply the best. Wish you the Best
Toronto "Elkar" wrote: Try this: =SUMPRODUCT(--(A1:A100=C1),--(B1:B100=D1)) This assumes the text string you're looking for is stored in C1 and the date you want to compare against is stored in D1. HTH Elkar "observer" wrote: I need help in sorting out this problem: count Certain type of Text Value in A:A only if the Date in B:B is after 2009-01-01 A B box 2008-01-02 cat 2009-02-02 box 2009-03-03 cat 2008-12-15 fox 2009-03-05 -- Toronto |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Employee Work Time - Don't Count Duplicates | Excel Worksheet Functions | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
![observer[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
