Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sum product if value present
I have a worksheet that totals dollar amounts from another worksheet 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, |
#2
|
|||
|
|||
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" wrote in message ... I have a worksheet that totals dollar amounts from another worksheet 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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Rows/Columns for Copying Formulas | Excel Discussion (Misc queries) | |||
Percentages | Charts and Charting in Excel | |||
How to set a formula to count the product appear how manytime | Excel Worksheet Functions | |||
Which Function(s) do I use? | Excel Worksheet Functions | |||
Which function(s)? | Excel Worksheet Functions |