LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
LesLdh
 
Posts: n/a
Default conditional sum - number of arguments problem

I have a conditonal sum that currently works fine as follows;

{=SUM(IF(Sheet1!$I$3:$I$5000="ProductType",IF(Shee t1!$K$3:$K$5000="T0",
IF(Sheet1!$O$3:$O$50001,Sheet1!$F$3:$F$5000,0),0) ,0))}

What I am now trying to do is to add another argument to filter the years
which are in column A in general format, something like;
IF(Sheet1!$A$3:$A$5000="2005",,)

When I use the Conditional sum wizard it works when I enter any combination
of two arguments, but when I try using all three I get the error;

"Run Time error '1004' Unable to set the ForulaArray property of the Range
class"

Can anybody help me to solve this, or can you only use two arguments with
the Conditional Sum wizard?

thanks, Les.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Number of arguments Weather Consultancy Services Excel Discussion (Misc queries) 6 August 23rd 05 07:16 PM
Conditional format problem PJ Excel Discussion (Misc queries) 2 March 11th 05 02:05 PM
Conditional formatting with dates formula problem. [email protected] Excel Discussion (Misc queries) 8 March 5th 05 11:47 PM
Conditional Formatting Problem msimpy22 Excel Discussion (Misc queries) 1 March 1st 05 04:17 AM
Count and Sum with Conditional Formatting Problem pmahajan Excel Worksheet Functions 1 December 14th 04 05:30 AM


All times are GMT +1. The time now is 04:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"