Conditional Sum Wizard

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

 

[Norman Harker]

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.

 

[andrew mackenzie]

Where this has worked on a different sheet the resulting
formula is:

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

Thanks.

 

[Norman Harker]

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.

 

[Andrew Mackenzie]

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]...


.

 

[Norman Harker]

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.

 

[Guest]

Unfortunately I have tried this and get #N/A which cannot
be right. Anyway thanks for your help.

Andrew

 

[Frank Kabel]

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