-----Original Message-----
to get dr. smith in january, try this in cell b1:
{=Sum(If(doc = a2,1,0)*if(month = b1,1,0))}
if both doc = dr. smith and month = january, it will
multiply 1 * 1 and add to the sum. if either or both of
the conditions doesn't work, the product will be 0, which
will not "count" in the overall total.
you can copy/paste or drag/fill the formula to other
cells to work for other docs/months.
hope that helps.
mike
.
