Can you please mark color yellow to those cells which needs to be sum !!
On Tuesday, May 19, 2015 at 6:18:46 AM UTC+5:30, sswcharlie wrote:
>
> Hi Mandeep
>
> Sheet attached.I want to check that the total of entries only adds up
> to grand total. A double check to make sure everything in. S
Hi Mandeep
Sheet attached.I want to check that the total of entries only adds up
to grand total. A double check to make sure everything in. Say total of
E11:E220
Thanks
Charles
On Monday, May 18, 2015 at 7:05:40 PM UTC+12, Mandeep Baluja wrote:
>
> Can we have the sheet ???
>
> On Mo
Can we have the sheet ???
On Monday, May 18, 2015 at 12:27:13 PM UTC+5:30, sswcharlie wrote:
>
> Hi
>
> XL2000
>
> Have searched for this with no luck.
>
> Have a column with figures entered by user and also some sub-totals as a
> result of formula.
>
> How do I have a formula to add all the ente
Hi Ashish,
Please find the attached macro file.
Regards,
MV
On Thursday, March 12, 2015 at 3:34:33 PM UTC+5:30, Ashish_Bhalara wrote:
> Dear experts,
>
> I need function to sum only closing value of particular date, pls see
> attached file for example.
>
> Regards.
> Ashish Bhalara
> 96241118
Hi
I do not know how to do this with using only one formula. I added column.
My method attached.
Waiting for somebody who use one formula. Maybe any array formula?
Regards
W dniu czwartek, 12 marca 2015 11:04:33 UTC+1 użytkownik Ashish_Bhalara
napisał:
>
> Dear experts,
>
> I need function to
Hi Vaibhav Bhai,
Superb Solution, Formula working great!!
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, acc
hey
check this..
cheers!!
ᐧ
On Fri, Jan 23, 2015 at 8:01 AM, MLT wrote:
> Vabz, At the bottom of the attached sheet, I highlighted 3 examples and
> what the expected return values would be for each example. The coloring is
> meant to show which ranges the example criteria would refer to. Is
Vabz, At the bottom of the attached sheet, I highlighted 3 examples and
what the expected return values would be for each example. The coloring is
meant to show which ranges the example criteria would refer to. Is there a
better way to show? Basically I'm lookin a formula that can count the
Can you add output sheet with desired result in it..i am unable to relate
ur explanation..
ᐧ
On Mon, Jan 19, 2015 at 9:03 AM, MLT wrote:
> File attached to try to be more clear on what I'm trying to do.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> =TIME(2,
File attached to try to be more clear on what I'm trying to do.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titl
to know that brother
>
>
>
>
>
> -- Forwarded message --
> From: Prince
> Date: Thu, Apr 11, 2013 at 5:13 PM
> Subject: $$Excel-Macros$$ Re: Sum on the basis of colour formula
> To: excel-macros@googlegroups.com
>
>
> Hi Modi,
>
> We c
Brother,
There is any formula based on the conditional formating or sumif based in
which we can recognise about the colour so i want to know that brother
-- Forwarded message --
From: Prince
Date: Thu, Apr 11, 2013 at 5:13 PM
Subject: $$Excel-Macros$$ Re: Sum on the basis of
Hi Modi,
We cant recognize colours in formula so only solution for the same is macro
regards
Prince
On Thursday, April 11, 2013 3:20:36 PM UTC+5:30, L.K.Modi wrote:
>
> Dear All
>
>
> In the given sheet i want sum on the basis of colour , is there any
> formula to solve my problem
>
>
> regards
Please try the simplest one...
=SUMIF(C2:C15,"<="&6500)+COUNTIFS(C2:C15,">6500")*6500
On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote:
>
> Dear Sir,
>
> I have a data in Range (C2:C50). There are values. I want to sum all
> value upto or equal to 6500, wherein values gre
Solution in Single Step
On Saturday, February 23, 2013 5:01:30 PM UTC+5:30, Ranjeet Negi wrote:
>
> Thanks, but is it possible to make one formula instead of two step.
>
> On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote:
>>
>> I see the answer in 2 steps, as attached
>>
>> IF &
Thanks, but is it possible to make one formula instead of two step.
On Saturday, 23 February 2013 16:45:09 UTC+5:30, Nitin Gupta wrote:
>
> I see the answer in 2 steps, as attached
>
> IF & SUMIF
>
> Regards
> Nitin
>
>
>
> On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote:
>>
I see the answer in 2 steps, as attached
IF & SUMIF
Regards
Nitin
On Saturday, February 23, 2013 4:06:15 PM UTC+5:30, Ranjeet Negi wrote:
>
> Dear Sir,
>
> I have a data in Range (C2:C50). There are values. I want to sum all
> value upto or equal to 6500, wherein values greater than 6500 wi
Hi Manoj,
I think we can not do it through formula only we can do it easly through
VBA. So below is the small code that we generate the same formula as you
want.
But it has some limitation eg. your sheets name should be continues like
[1,2,3.] except the sheet name Report.
Dim rngCells
Please give logic(what where why) of what you want with EXAMPLES.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Attapan
Sent: Wednesday, August 15, 2012 10:15 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Sum up of Bill of material
Sorry for unclearify questions and example
I posted new file, please see my requirement and example
On Wednesday, August 15, 2012 6:15:16 PM UTC+7, Attapan wrote:
>
>*Dear Expert*
>
> Please help me on Excel function
>
> *Questions*
>
> 1
>
> I've 2 sheet (BOM and Forecast)
>
Hi,
Have you thought about a pivot table before going coding a macro?
cells(i,j) notation is about 2 dimensional array. If you want to work any
values in there, you then need 2 loops. Now, you must know before hand
which direction you need to take, are you going by rows or by columns? This
is w
Good to know.
You are welcome.
Regards,
DILIPandey
On 6/6/11, ayoub Kakande wrote:
> Thank you sososo much,
> it has worked out just perfectly
> thanx again.
>
> On 5 June 2011 20:58, Dilip Pandey wrote:
>> Hi Ayoub,
>>
>> If you remove the named range and type the desired cell reference like
>
Yes, this might be true as there is one range name used in formula,
defined by the name of "dkp", which you should first create the same
in your Excel. Alternatively, you can manually replace the NAME used
in formula with actual cell refrences to make it more dyamic.
Feel free to revert in case of
Hello,
does that formula apply to only office 03 coz when I copy it to my
original workbook which is in office 7 it brings a name error
On 1 June 2011 09:06, Dilip Pandey wrote:
> HI Ayoub,
>
> This is done with the help of nesting formula having functions like
> Small, Row and Sum.
> See the att
Hi Ayoub,
It would be very helpful for the "Group" if you can share a sample
scenario of your problem.
Thanks,
DILIPandey
On May 31, 2:45 pm, ayoub Kakande wrote:
> Urgent help needed
>
> I have 18 subjects, 6 of them are compulsory from the other 12 a
> student offers only 2 to make a total of
Dear Subu,
This can be accomplished with Sumproduct function.
Please send a sample sheet, I can work it out for you.
Regards,
Andy
On Sun, May 31, 2009 at 7:40 PM, Subu wrote:
>
> Dear Members
>
>
> 1. I have a table with columns A, B, C, D, E, F,
>
> 1.1. Column A has the range of values
What does paracept and ceizg mean?
Thank you.
From: tinu...@baja.hu
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Sum
Date: Tue, 5 May 2009 23:37:57 +0200
Brilliant!
From:
excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of
Brilliant!
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Dilip Pandey
Sent: Tuesday, May 05, 2009 5:08 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Sum
Hi Skanda,
Please find the attached solution.
Thanks &
Hi Skanda,
Please find the attached solution.
Thanks & Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Sat, May 2, 2009 at 1:24 AM, Skanda wrote:
> Columns A and B give the sum of ceizg and
HI Skanda
SEE ATTACHED EXCEL FOR SOLUTION
LET ME KNOW
JAYAVELY
On Sat, May 2, 2009 at 1:24 AM, Skanda wrote:
> Columns A and B give the sum of ceizg and paracept in each row.
> Is there any formula that sums all the values of "Ceizg" ad "Paracept".
> e.g:96,00 is the sum of al
Hi Skanda,
I just realized that you would want to sum all the cells with the headings
either Paracept or Ceizg at one go.
In that case you can simply use the formula:
=SUMPRODUCT((C2:BD2="CEIZG")*C3:BD5) -- for "CEIZG"
Please replace the cell references as per your original range.
=SUMPRODUCT((C
Hi Skanda,
Please find attached the solution file.
Regards,
Andy
On Sat, May 2, 2009 at 2:54 AM, Skanda wrote:
> Columns A and B give the sum of ceizg and paracept in each row.
> Is there any formula that sums all the values of "Ceizg" ad "Paracept".
> e.g:96,00 is the sum of all "paracept"
32 matches
Mail list logo
