That's precisely what the =SUMIF() formula is for.
Digit =SUMIF( and press for help to see how it's used. It's very simple.
On Mon, Sep 6, 2010 at 4:19 PM, Idhrees Mohamed wrote:
> Dear Guys
>
> I have two column, job no & value. In this i need particular job no with
> the total value in serial w
Try the following array formula:
=MAX((A1=Sheet2!A1:A5)*(B1=Sheet2!B1:B5)*Sheet2!C1:C5)
Adjusting the ranges "A1:A5", "B1:B5" and "C1:C5" to the respective ranges
on sheet2.
Just to remember, to use an array formula you should paste the code and then
press CTRL+SHIFT+ENTER (if you just press ente
Your formula is perfect. But the Calculation Options are set to "manual", so
you need to press F9 to calculate (or go to "calculation options" and check
"automatic")
Regards,
Bruno
On Wed, Sep 1, 2010 at 1:19 PM, Kurt wrote:
> Posted it to the file list. It's called ISERROR Example.xls.
>
>
> O
Just for curiosity, do you really want to put all the information in the
same cell?
For example, instead of putting in the "this month" cell [*A Swanepoel, D
Michaels, E Fielies, F Ntinga, G Deafe*], don't you think it would be better
if you had 1 name per cell? Or is this way of displaying names n
I think you're looking for the _Change event.
For example, if your criteria for the first textbox be complete is it having
2 numbers, you could use:
Private Sub TextBox1_Change()
If Len(TextBox1.Value) = 2 Then TextBox2.SetFocus
End Sub
Regards,
Bruno
On Thu, Sep 2, 2010 at 5:17 AM, neil johnson
:
*COUNTA(INDIRECT("'PRD Range'!D:D"))*
So, counting the non-blank cells in range D, we got to know our 5th element
(in the example, *6*).
After joining this 5 informations together, our formula is reduced to:
*=INDIRECT(**"'PRD Range'!D2:D6")*
What is p
Hm, for some reason I only received this email after I send the last one.
Ashish's solution is much more elegant than mine.
Please forgive for sending useless attachments to your emails.
On Sun, Aug 29, 2010 at 5:32 AM, ashish koul wrote:
> check the attachment if it helps
>
> On Sun, Aug 29, 2
See if this helps.
Regards,
Bruno
2010/8/24 ̉‰Shine
> Thank you Ashish. I appreciate your effort and time you spent for it. But
> I am looking for a combination function that can do the job. VBA cannot be
> used
>
> Thank you
>
> Best Regards
> Shine
>
>
> On 23 August 2010 20:52, ashish koul
Excel 2003 - 7 nested IF's
Excel 2007 - 64 nested IF's
On Sat, Aug 14, 2010 at 10:43 AM, Angelo Spinola wrote:
> Hi, Thanks for the feedback,
>
> So what i mean is how many nested IF's can i have?
>
> Regards,
> Angelo
>
> 2010/8/14 Bruno Bruno
>
&g
gt; thanks, yes, is the number of if iteration ilimited?
>
> Regards
>
>
> 2010/8/12 Bruno Bruno
>
>> See if it's this what you want.
>>
>>
>> On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola > > wrote:
>>
>>> Dear Bruno,
>>>
>&g
esire that is result.
>
> Regards,
> Angelo Spinola
>
> 2010/8/12 Bruno Bruno
>
> Hi Angelo,
>> I'm still confused about exactly what you want. Are you really sure you're
>> looking for an iteration?
>>
>> You say that If in cell A1 i have "aaa"
mply change the
string with a formula?
Regards
On Wed, Aug 11, 2010 at 6:51 PM, Angelo Spinola wrote:
> Dear Bruno,
>
> Thanks for the feedback.
>
> If in cell A1 i have "aaa" it should stay the same, but if i have "bbb" it
> should be changed to "ccc"
Hi,
I am not pretty sure of what you want, but aren't you looking for a simple
formula? Something like:
=IF(MOD(CODE(A1);2)=1;A1;REPT(CHAR(CODE(A1)+1);3))
Where A1 is the cell with "aaa"
On Tue, Aug 10, 2010 at 6:23 PM, Angelo Spinola wrote:
> Hello,
>
>
> How can i create and iteration for:
>
My friend Prathap,
Yes, there is. I did it in the Sample I am returning to you, but I would
strongly recommend other simpler ways to do it.
The point is that up to Excel-07, microsoft has not implemented any default
functions that deals with cells background colors (if I am wrong, somebody
tells
14 matches
Mail list logo