window 7

Here is what i am trying to do….is there one formula that would work? In J2, I want to sum L2:R2 where the value of any text in each cell is = to ‘1’ and S2:V2 where the value of any text in each cell is = to ‘.6’. A blank cell would have no value. For example, If L2, M2, and N2 had the words...

hey guys i am getting this subscript out of range error on my a program in excel set up at my work. The problem is that it was set up a long time ago and it has been converted many times and now it barely works. I fixed most of the errors on it but i am still getting an error on this substring...

<TBODY> Hi evryone,</SPAN> I have the following table in sheet-1 from an excel workbook. I want an excel formula that can allow me to automatically add a row to similar table in sheet-2 if I add it to the main table in sheet-1.</SPAN> Example: If I add a row with the name...

Hi all, I've recently been working on developing a fairly complex workbook (at least by my standards) that involves the use of a number of user forms to enter and edit data. I created the workbook in Excel 2010 on my now four year old Windows XP netbook. On the netbook the user forms display...

I have a report I download weekly from the corp. site. It contains sales stats for the previous week. I spend a lot of time rearranging the data so I can prepare weekly presentation for several managers. I built macros that deleted the column I don't need and that really sped things up. But...

Hello, I'm new to the board and it would seem Excel by looking at the advanced nature of most of the post regarding my issue. So, please bear with me while I play catch up. I'm having issues with a macro that i've recorded in my personal workbook that I intend on using on variable lenths of...