auto adjusting

I'm trying to get a formula that will check an array of 8 cells for "Y", and if true sum the adjacent (-1) cells, and move the arrays X*7 columns over. A static formula that works is SUMIF( X2:X9, "=Y", W2:W9) = 15 where the X is 4 (7*4-5). The problem with this formula it doesn't adjust when a...

I have a userform that has various codes that are beingmistaken by excel as date format or something and it keeps changing my formatautomatically. The few of the code types are below. 1 2 3-5 3-17 3-23 3-61 7-81 7-86 How can I get these to stop changing when the userform macroexecutes and...

Good day... I'm new in this forum... I have a spreadsheet that uses filter to narrow down my search/selection but the gross value doesn't change. I would love an excel shhet that has the corresponding gross value as the filter changes. I can send you a dummy file for clarity. Best, Akpflow...

Hello, I am not completely sure if this is possible, I have a table like below: <tbody> A B C D E F G H 7/1/2015 1500 2400 3600 7/2/2015 1500 1500 3600 7/3/2015 1600 2400 3600 7/4/2015 1600 3600 1800 7/5/2015 2400 3600 1600 ETC.... </tbody> If...

Hey Guys, I appreciate any help that anybody can offer. I am making a presentation formatted in Excel, and I have run into a small problem. The presentation has a section that is updated frequently that requires a good bit of time to adjust. What I have in place right now is series of boxes...

One sheet of my workbook is a master summary sheet where data is entered. Column A contains numbers that we use as a VLookup Reference key for other sheets in this workbook. Example: Master Summary Sheet 1 Bob 2 Fred 3 George 4 .... 105 Now, I want other sheets in this work book to only...