I need help!
Is there a formula which can be used to add certain criteria in 1 column with a certain criteria in another column, eg;
Cells in Column A has either Open or Closed in it.
Cells in Column B has a month in it (Jan, Feb etc)
I need to get a figure of cases that are "open" in "january", how would I go about that?
Is there a formula which can be used to add certain criteria in 1 column with a certain criteria in another column, eg;
Cells in Column A has either Open or Closed in it.
Cells in Column B has a month in it (Jan, Feb etc)
I need to get a figure of cases that are "open" in "january", how would I go about that?