URGENT HELP - SUM FORMULA
Please note Isabelle's use of the double unary -- which is the
correct method.
I forgot to enter it in my formula.
Should have been
=SUMPRODUCT(--(F2:F5="Open - Active")*(G2:G5<"Gvt Invest")*(H2:H5))
Gord
On Thu, 05 Jan 2012 17:19:29 -0800, Gord Dibben
wrote:
=SUMPRODUCT((F2:F5="Open - Active")*(G2:G5<"Gvt Invest")*(H2:H5))
I get 1000 'cause only F2:J2 meet the criteria.
Gord
On Thu, 5 Jan 2012 15:47:48 -0800 (PST), Michelle
wrote:
I have another question: How do I get a sum total of cells if the
cells meet certain criteria? meaning, ony add the reserve to the total
if the status is Open - Active and the Nature of Case is NOT
Government Investigations?
F H J
STATUS NAT OF CAST RESERVE
Open - Active EEOC 1000
Open - Active Gvt Invest 2000
Open-Probable EEOC 2000
Open - Probable Gvt Invest 1000
|