B
Brandy
These are the two formulas I'm using. Do you see any
errors that pop out at you? If not, can you help me
figure out a way to make this work? Column F is gender so
the only options are M or F. Column G is ethnicity so the
only options are A,B,C,H,N,M,and O. Column T is the level
of placement, so the options are 1,2,3,4, or 5. The
formulas are intended to exclude data without these
criteria in a total count.
=SUMPRODUCT(--(F6:F232="F"),--(G6:G232="C"),--
(T6:T232="1"))
=SUMPRODUCT(--(G6:G232="C"),--(T6:T232="1"))
Column G is Ethnicity where the only options are
A,B,C,H,N,M, and O. Column A is the date of the
referral. This particular problem is that I need it to
calculate how many clients met these criteria in a
specific month.
=SUMPRODUCT(--(G6:G464="C"),--(TEXT(A6:A464,"mmm")="Oct")
*1)
=SUMPRODUCT(--(F6:F464="F"),--(G6:G464="C"),--(TEXT
(A6:A464,"mmm")="Oct")*1)
errors that pop out at you? If not, can you help me
figure out a way to make this work? Column F is gender so
the only options are M or F. Column G is ethnicity so the
only options are A,B,C,H,N,M,and O. Column T is the level
of placement, so the options are 1,2,3,4, or 5. The
formulas are intended to exclude data without these
criteria in a total count.
=SUMPRODUCT(--(F6:F232="F"),--(G6:G232="C"),--
(T6:T232="1"))
=SUMPRODUCT(--(G6:G232="C"),--(T6:T232="1"))
Column G is Ethnicity where the only options are
A,B,C,H,N,M, and O. Column A is the date of the
referral. This particular problem is that I need it to
calculate how many clients met these criteria in a
specific month.
=SUMPRODUCT(--(G6:G464="C"),--(TEXT(A6:A464,"mmm")="Oct")
*1)
=SUMPRODUCT(--(F6:F464="F"),--(G6:G464="C"),--(TEXT
(A6:A464,"mmm")="Oct")*1)