|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 16th, 2009, 02:51 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT 00-Jan-00
Hello,
I am using following formula, when Sheet = Payment cell D9  1000 doesn't match value = Clear error value is coming in $K614 00-Jan-00 which I really don't want, I just want as empty cell, is there any solution ? =SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D 9:$D1000="Clear"),(Payment!$W9:$W1000)) 
|
|
#2
May 16th, 2009, 05:30 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT 00-Jan-00
Hi
I'm not sure that I understand your question, but my guess is that you want to wrap the formula in an IF() =IF$K6141,"", SUMPRODUCT((Payment!$G9:$G1000=$K614)* (Payment!$D9:$D1000="Clear"),(Payment!$W9:$W1000)) ) -- Regards Roger Govier "Tufail" wrote in message ... Hello, I am using following formula, when Sheet = Payment cell D9 1000 doesn'tmatch value = Clear error value is coming in $K614 00-Jan-00 which I really don't want, I just want as empty cell, is there any solution ? =SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))
|
|
#3
May 16th, 2009, 05:34 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT 00-Jan-00
Your result cell must be formatted as DATE hence the result 0 is shown as
0-Jan-00. If you don't want to show 0s then format the cell with CUSTOM format #;;;@ "Tufail" wrote: Hello, I am using following formula, when Sheet = Payment cell D9 1000 doesn't match value = Clear error value is coming in $K614 00-Jan-00 which I really don't want, I just want as empty cell, is there any solution ? =SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))
|
|
#4
May 16th, 2009, 06:07 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
SUMPRODUCT 00-Jan-00
No probs with your formula...Check the cell format///
-- If this post helps click Yes --------------- Jacob Skaria "Tufail" wrote: Hello, I am using following formula, when Sheet = Payment cell D9 1000 doesn't match value = Clear error value is coming in $K614 00-Jan-00 which I really don't want, I just want as empty cell, is there any solution ? =SUMPRODUCT((Payment!$G9:$G1000=$K614)*(Payment!$D 9:$D1000="Clear"),(Payment!$W9:$W1000))
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
