Re: Sum product if value present

Is this what you want?

=SUMPRODUCT(--('JULY 2005'!$D$5:$D$53="KB"),--ISNUMBER('JULY
2005'!$L$5:$L$53),(IF(ISNUMBER('JULY 2005'!C5:C53),'JULY 2005'!C5:C53,'JULY
2005'!$B$5:$B$53)))

This is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

RP
(remove nothere from the email address if mailing direct)


"tifosi3" <tifosi3@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2226CFC0-9E9B-4D91-A829-9CBCBF4CF329@xxxxxxxxxxxxxxxx
> I have a work*** that totals dollar amounts from another work*** based
on
> certain criteria. The current formula is: =SUMPRODUCT(--('JULY
> 2005'!$D$5:$D$533="KB"),--ISNUMBER('JULY 2005'!$L$5:$L$533),('JULY
> 2005'!$B$5:$B$533))
>
> I have now want to be able to in certain instances be able to enter
another
> value in column, and if I do I want it to use the column C value not the
> column B, and if there is no value in C use the coulumn B value.
>
> I know I should be able to figure this out, but for some reason I am
drawing
> a complete blank. Thanks in advance for any help!!
>
> Regards,


.