Hi, I have a problem that I have no idea how to approach.
I have two columns of data, B2:B40 and D2:D40. I wish to count every occurrence where Bx is equal to 5, AND Dx is equal to 400. (x indicates the same row) I expect this spreadsheet to grow a few hundred values every week. Any pointers? I am using Excel 2003.
Thanks
Last edited by quaaark; 10-23-2009 at 11:55 PM.
Try this with a range sufficient to allow for some period of expansion before you adjust it:
=SUMPRODUCT(--($B$2:$B$1000=5), --($D$2:$D$1000=400))
...and welcome to the forum!
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Wow, I never would have thought of using SUMPRODUCT like that. Ah well, now I will.
Thanks!
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks