Formulas Still Not Working
On Jan 6, 2:06*pm, Claus Busch wrote:
Hi Michelle,
Am Fri, 6 Jan 2012 12:02:46 -0800 (PST) schrieb Michelle:
Thanks. The result I get is #VALUE.
try:
=SUMPRODUCT(--(A1:A20="Open - Active"),--(B1:B20="GVT Invest"),C1:C20)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Claus - this worked! I placed the formula in all chree cells, and
updated to capture the ranges I need, etc., and the calculations work
correctly. Truly, from the bottom of my heart - I thank you ALL! I
also think Im going to take an excel class! You are all amazing, and I
wish I could thank you all in person!
|