Sumproduct

[lars]

Here is my formula

=SUMPRODUCT(('327'!$C$6:$C$424=B34)*(MONTH('327'!$F$6:$F$424)>=5)*(MONTH('327'!$F$6:$F$424)<=8)*('327'!$R$6:$R$424))

my question applies to the last part *('327'!$r$6:$r$424....I need this part to look at two columns instead of just "R" and bring back whichever one is greater.

If the sum of column M is greater than S than use M or use S if that is greater

I used this for the last part and it works alone but not with the sumproduct formula
*((IF(SUM('327'!$R$6:$R$424)>SUM('327'!$S$6:$S$424),SUM('327'!$R$6:$R$424),SUM('327'!$S$6:$S$424)))))

Any help would be great

thanks

 

[lars]

I want the formula to look at a particular ship then look at if it falls within a certain date once it's done that look at two deifferent columns and whichever is greatest use that number. the two columns have more than one number so it needs to add the numbers together in each column then determine which is largest

Does that make sense?

 

[lars]

option 1 is what I'm looking for

 

[Jay Petrulis]

On 2002-04-09 14:52, lars wrote:
option 1 is what I'm looking for

Hi Lars,

It appears that Aladin's first formula answers your request. Just make sure your ranges are properly specified.

Jay

 

[lars]

Jay, your formula worked but the numbers are off slightly not sure why yet.

Thanks

I'll give Aladins a try

 

[Jay Petrulis]

On 2002-04-09 15:10, lars wrote:
Jay, your formula worked but the numbers are off slightly not sure why yet.

Thanks

I'll give Aladins a try

Hi Lars,

My formula was for option 2, not option 1. I think Aladin's first formula will do the job.

Jay

 

[lars]

It did the job thanks


Thanks Aladin!