Search results

Hello, I have a report for different units, and based on a list or criteria, I need to add the values for only those units. How can I get a formula that will work with a regular list (no empty rows to match the rows)? I got it to work with an array formula, "SUM(IF(...", but only when the...

Hello, I am creating a PowerPivot report for supplies consumption, which contains: Beginning Inventory Forecasted Demand Actual Demand Plan Receipt and the measure is: [Projected on Hand] = If([Actual Demand]>0, [Beginning Inventory] + [Plan Receipt] - [Actual Demand], [Plan Receipt] -...

Hi all, I have an inventory count list of few thousand items. The fields are: location, item number, description, quantity and date. In the same file I have data from June and July. By using a Calculated Field in a Pivot Table, how do I calculate the inventory change from June to July (the...

Hello Chandoo and Excel community, I am currently using “SUMIFS” to compile data using 3 different criteria (Business Unit, Account and Department). The formula covers over 1,000 lines for different results. The raw data that I am pulling from has 40,000 lines. I have set up named ranges and...

Hi all, I need to track severance payments, which are paid every other Friday (bi-weekly). My schedule (reconciliation) is done on a monthly basis, so I track the monthly activity to the accounting system (ledger). Now the problem I have is how do I estimate the right number of payments each...