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 |
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 |
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 |
All times are GMT +1. The time now is 02:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com