Array Formula isn't summing but counting

S

SPenney

I need to sum information based on several other criteria -- accoun
number, sort codes, company names. The array formul
{=SUM(A1:F25="A")*(E1:E25>0))} returns a count rather than a sum

Does anyone know of a way get it to add my data rather than countin
how many?

Staci
 
F

Frank Kabel

Hi
if you want to sum column E try the array formula
=SUM((A1:F25="A")*(E1:E25>0)*(E1:E25))

or a non array formula
=SUMPRODUCT((A1:F25="A")*(E1:E25>0),E1:E25)
 
B

Bob Phillips

Stacie,

You are summing the number of

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

Stacie,

You are summing the number of items that match your criteria, which
effectively is a count. If you want to sum, try

=SUM((A1:F25="A")*(E1:E25>0)*(E1:E25))

still array entered

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
J

Jonathan Rynd

Does linking across workbooks affect the formulas?
Click to expand...

Could you be more specific -- what do you mean by 'linking across
workbooks'? Could you post the exact formula you are using?
 
Top