Array Formula isn't summing but counting

  • Thread starter Thread starter SPenney
  • Start date Start date
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
 
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)
 
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)
 
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)
 
: Does linking across workbooks affect the formulas?
:
: S
:
:
: ---
: Message posted
:
 
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?
 
Back
Top