Conditional Sum Wizard

  • Thread starter Thread starter andrew mackenzie
  • Start date Start date
A

andrew mackenzie

Hi, Can someone help/
In trying to use the Conditional Sum Wizard I get the
message "The formula you are building is too long. Please
specify fewr conditions".
The problem is that 1) I am only specifying one condition
and 2) I have used exactly the same methodology on a
different sheet for an almost identical lsit with no
problem.
Thanks.
 
Hi Andrew!

What's the formula or description of what you want to sum.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Where this has worked on a different sheet the resulting
formula is:

=sum(if($o$41:$o332=A5,1,0))

Thanks.
 
Hi Andrew!

Are you entering the formula as an array?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Yes, i.e. Ctrl-Shift-Enter

Rgds
-----Original Message-----
Hi Andrew!

Are you entering the formula as an array?

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
message news:[email protected]...


.
Click to expand...
 
Hi Andrew!

If the conditional sum wizard is letting you down, then try a manual
entry for the conditions you want.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Unfortunately I have tried this and get #N/A which cannot
be right. Anyway thanks for your help.

Andrew
 
Hi
try the following formula based on your first example in a previous
post
sumif($o$41:$o332,"=" & A5)

or you may provide some more details about your current spreadsheet
layout and what you're trying to sum to get a more specific answer :-)
 
Back
Top