needed

I need 2 SUMIFS formulas I have 2 worksheets; SALES & STATS on STATS H28 is where the formula is needed. I need the formula to SUM S6:S1005 IF both criteria in SALES I6:I1005 = "CL" and SALES E6:E1005 = "B" Same formula needed for Y17:Y28 with the exception of E6:E1005 = "S"

This is hard without being able to upload a WS but here it goes. I basically need a 2 SUMIFS formula I have 2 worksheets; SALES & STATS On STATS M17:M28 starting on M17 I have al 12 months of the year listed as 1/1/2017, 2/1/2017, etc. on STATS W17:W28 is where the formula is needed. STATS...

Hi, I am working on simplifying my code to make it easier to follow and check for errors, and I am wondering how often the suffix .Value is needed to determine the value of a cell reference. I would imagine you need the .Value to assign variables (eg x = Cells (r, c).Value) but is it necessary...

Good morning. I'm working on this stuff with the help of the macro recorder. But clearly it's not exaustive for specific needs. I've a workbook named "source". Starting from a sheet named "last" of this workbook, I've to generate a new workbook with some datas and sending it in csv format to...

Need formula in cell D4 that will search My sheets "JAN" through Content of cell D2 - "MAR" and sum the total of all records in the sheets that Match the Acct# given in my Cell B4. Can someone assist me? Excel 2010 <tbody>#DAE7F5[/URL] "] A B C D E F G H I J K L 1 Through: Have...

I'm using this code provided by Marcelo Branco to visually highlight a cell when it becomes the active cell by changing its font color to orange, then changing the font color back to black when the user clicks elsewhere and the cell becomes non-active. The SelectionChange event works great...

Hey all, I want to calculate how many calls is needed (answered in Service Level column C) to reach the target (column G). In below example this would be 1156, not taking in account that calls are abandoned. So incoming calls and answered calls will increase. How can is calculate this using the...

Hi All, Please help me with excel vba code to extract reports from peoplesoft. I tried searching in google but was not successful. I have access to only excel and cannot download any third party tool. Everyday I need to download data from peoplesoft I needed to automate this task that almost...

I'm fairly new to Excel so bare with me. I'm trying to figure out a formula that will add how many 10' lengths of any given material needed. For example if If I need Qty. 30 32" pieces cut out of a 10' length, how may 10' lengths do I need?

So I'm trying to use a vlookup to check a table of a few values, and only print the numbers if the value is more than zero. Column A returns the value in Column C IF Column D is at least 1 or higher. If Column D is zero, Column A skips the Column C value. I have approx 3000 rows to validate...

Hi There, I am looking for a dashboard which can be modified as per the analytical needs and also can be utilized for various types of data sets. Can anyone help in the same. Regards, Darpan Sharma