excel: count text under same dates

Microsoft Excel 97 upgrade
January 30, 2011 at 23:43:13
Specs: Windows 7
Hi, please help me in excel:

I need to count certain text for every date:


column a has dates 1/20/2011, 1/20,2011, 1/31,2011, 1/31,2011
column b has apple apple orange apple

i need to count apple in column b under 1/20/2011 date only

See More: excel: count text under same dates

January 31, 2011 at 06:24:53
Read up on the COUNTIF function in the Excel Help files.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question