I was looking through one of my old sheets and came across this:
=SUMPRODUCT(--(I4:I1151=3),--(J4:J1151=1))
I can't remember for the life of me how I figured out that would count the occurrences of the two conditions. Any idea what the "--" does? If I take them out excel doesn't count any instances where the criteria are met.
Thanks in advance.
I'm not an expert on binary conditions, but whenever I feel the need to use sumproduct I have this link in my favourites to provide me with lots of advice on how this works.
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
Terry
"... I thought I was a power user of Excel until I came onto these boards..."
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks