All, I have a multi-level bill of material and I want to create a function that will sum it properly without having to sum up each level manually. Here is...

AND...I'd be more than happy to pass along the actual worksheet if that would be helpful...

"Max" wrote: In your summary tab, place this in any starting cell, say in B2: ...

WAIT! I think I got it - can someone confirm this is accurate? Sub Macro() Dim lngRow As Long Dim intA As Integer, intB As Integer, intC As Integer, intD As...

I almost have it but am getting an error. If i am interpreting the formula correctly, it says to give me the value in Sheet2 column c when both column a and...

Try the below in cell D1..with data in Sheet1 and query values in current sheet...

Assuming number of people is in column A and group work is in column B, use the following adjusting the range as...

When you have multiple criteria use SUMPRODUCT() =SUMPRODUCT((A1:A10=criteria1)*(B1:B10=criteria2),E1:E10) If you are using Excel 2007 you can use SUMIFS()...

Thank you Jacob: OK - I ran the macro and it resulted in a three column table of 27 rows....My apologies if I did not explain my intentions correctly.. I have...

Hi, Could any one show me how I can compare two worksheet to find out if there are any difference. The 2 worksheet might contain data like Name in column A...

I have a sales receipt worksheet that has all my sales items on it. I also have an inventory worksheet. I would like when I make a sale that it automatically...

Please tell me how to do this.

Working in Excel, I am looking for help using fill-in boxes. I am creating a form. Setting up a cell or a bunch of cells merged where you can enter a...

I have an excel file that contains multiple templates that I need to copy depending on certain criterion. I have set up two columns for this purpose. The first...

Hello, Could you please let me know if its possible to be able to group or ungroup (groupings already set up) while an excel workbook is protected and...

School Pupil ID LastName FirstName Grade Course/Grade Clear Creek 210310 Archer Heath 5 MUSIC S Clear Creek 210310 Archer Heath 5 SOC...

=SUM(--('Sheet1'!$B$2:$B$2000=BB$3),--('Sheet1'!$B$2:$B$2000=BB$2),--('Sheet1'!$D$2:$D$2000=$B7),...

I have a table listed with columns Product Unit Of Measure Cost % Markup I have products number repeated twice one for unit of Measure "CS" and another for...

Try this one liner Range("I2:I" & Cells(Rows.Count, _ "A").End(xlUp).Row).Formula = Range("I2").Formula OR Sheets("Sheetname").Range("I2:I" &...