Sum product if value present

From: "tifosi3" <tifosi3@xxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 5 Jul 2005 14:27:01 -0700

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

Follow-Ups:
- Re: Sum product if value present
  - From: Bob Phillips

Prev by Date: Re: Need some help returning a value
Next by Date: can it be done without vb
Previous by thread: Need some help returning a value
Next by thread: Re: Sum product if value present
Index(es):
- Date
- Thread