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 idhrees...@gmail.comwrote:
Dear Guys
I have two column, job no value. In this i need particular job no with
the total
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 enter, it
+(MATCH('Dropdown List'!$B$7,Brand,0)26)
Regards,
Maries
On Mon, Aug 30, 2010 at 5:58 PM, Bruno Bruno brunobbr...@gmail.comwrote:
Hi Kalyan,
See if this helps.
Regards,
Bruno
On Mon, Aug 30, 2010 at 6:04 AM, Kal xcel kalx...@gmail.com wrote:
Dear Experts,
I need a help
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 koul.ash...@gmail.com wrote:
check the attachment if it helps
ilimited?
Regards
2010/8/12 Bruno Bruno brunobbr...@gmail.com
See if it's this what you want.
On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola spinolaang...@gmail.com
wrote:
Dear Bruno,
I will send you an attachment, so i can make this clear. Result is based
on size and code as you can
Excel 2003 - 7 nested IF's
Excel 2007 - 64 nested IF's
On Sat, Aug 14, 2010 at 10:43 AM, Angelo Spinola spinolaang...@gmail.comwrote:
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 brunobbr...@gmail.com
Angelo, I
that is result.
Regards,
Angelo Spinola
2010/8/12 Bruno Bruno brunobbr...@gmail.com
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 it should stay the same, but if i
have bbb it should
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 spinolaang...@gmail.comwrote:
Hello,
How can i create and
spinolaang...@gmail.comwrote:
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.
Regards
2010/8/11 Bruno Bruno brunobbr...@gmail.com
Hi,
I am not pretty sure of what you want, but aren't you looking
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
10 matches
Mail list logo