Search results

I wrote a formula which was working properly until I added some additional records to the table. Now the formula calculates correctly, but at the last step it rewrites the answer to match the result of the copied cell. This is the formula: Here is the correct calculated result (after stepping...

I have a pivot table grouped by slicers. I want to exclude 0 amounts in the groups. However, I've found that when I use filters to exclude 0's, the rows with the 0's in them are hidden, so when I click on a different slicer, the row is still hidden and anything that would have been displayed on...

This one has me stumped. Formula reads: =IFERROR(INDEX(RawBudgetAmt,MATCH(1,((MID(RawBudgetAcct,3,3)=$A23)*(MID(RawBudgetAcct,14,6)=$B23)),0)),0) entered CSE. What I'm attempting to do is a lookup based on 2 criteria. Because I'm testing, each cell should return 100. I get 0. When I click in...

I have a workbook with a pivot table on one sheet (Pivot Budget), and a form with the "getpivottable" data on another sheet (Completed Budget). I have created a slicer for the pivot table and placed the slicer on the sheet with the form. All was well & good until I protected the sheet with the...

I have a worksheet where I have created several named single-column ranges using the offset function, i.e. =OFFSET(Reformatted!$B$2,0,0,COUNTA(Reformatted!$B:$B),1). I created a sumifs formula using these named ranges and I get a #value error. If I use a standard criteria range of...

Hello Experts! After reading through several blog posts suggesting that volatile functions should be used sparingly, I am trying to rebuild a workbook that uses indirect in a rather wanton fashion (250 times per sheet X 10 sheets). There is a sheet for each month of the year (named "January"...

I have some rows with calculations, which I include in a round function (=round(calculation,2). The rounding calculation works fine, but when I sum two cells that use the round function, the sum doesn't always calculate correctly. It's not obvious either, until I export the file for import to...

I'm using Excel to allocate an amount based on the percentage of a cell to the total. The formula is Round((A2/A200)*B1,2), copied down the column. All the amounts in column A are 2 decimal amounts, as is the amount in cell B1. The challenge comes when I then sum all the rounded amounts . . ...