I hope you can help. I have a spreadsheet that records entry by date added
(column A). Each entry can be assigned to at least 1 person (column M).
However, there are times when an entry can be assigned to 2 people. The
second entry is in column N. Both column M and N use the same drop down
lists. I need to count how many items received each month that were assigned
to a person (who could be listed in either column M or N). I have formulas
that count how many are assigned to a person -- =COUNTIF('EI
Inventory'!M:M,"J Smith")+COUNTIF('EI Inventory'!N:N,"J Smith"). I have a
formula that counts how many entries per month were assigned to a person in
Column M -- =SUMPRODUCT((ISNUMBER(SEARCH("J
Smith",M:M)))*(A:A<=--"10/31/2009")*(A:A--"10/01/2009")). I need a formula
that counts for both Column M and N. Please help.
Thanks!