Hi,
I am looking for a function that allows me to count number of line items that fulfill the following 2 criteria:
1. Company name matches
2. Date is prior to TODAY
I attached an excel file as an example.
Regards
k
Hi,
I am looking for a function that allows me to count number of line items that fulfill the following 2 criteria:
1. Company name matches
2. Date is prior to TODAY
I attached an excel file as an example.
Regards
k
You dont give much data to go on, nor do you show any expected results?
You probably need to use COUNTIFS though.
oh and by the way, Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile says 2003, but your file indicates at least 2007
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
try this...
=COUNTIFS('raw data'!A:A,check!A2,'raw data'!B:B,"<"&TODAY())
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks