Dear all,
The question is quit simple but I cannot seem to find the right answer.
I have one sheet "FF" which shows categories of companies (1-48) and each of these categories include several SIC numbers.
What I now want is to find the right category (1-48) for each SIC code in my second sheet.
Try this, copied down....
=SUMPRODUCT((FF!$A$2:$A$599)*(IPO!B2*1>=FF!$C$2:$C$599)*(IPO!B2*1<=FF!$D$2:$D$599))
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
Or this
=SUMIFS(FF!$A$2:$A$599,FF!$C$2:$C$599,"<="&B2,FF!$D$2:$D$599,">="&B2)
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Nice 1 AlKey, I didnt think of using sumifs()
Both work, thank you very much for the quick response!
Happy to help and thanks for the feedback
Thank you for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks