Array Formula isn't summing but counting

[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

 

[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)

 

[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)

 

[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)

 

[SPenney]

Does linking across workbooks affect the formulas?

S

 

[Lady Layla]

: Does linking across workbooks affect the formulas?
:
: S
:
:
: ---
: Message posted
:

 

[Jonathan Rynd]

Does linking across workbooks affect the formulas?

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