I am a newbie with excel, so I'm hoping someone can help out.
in the workbook I'm working on, I have multiple tabs with data spread out.
Tab 1 contains a list of resources and the dates they will end support. Unfortunately, some list the full name, and others list just the first...
I am using the SUMIF formula to pull the sum of each location by month from corresponding sheets, See the photo below for my comparison sheet I am creating.
We will use the first location "Ann Arbor Education Center" as an example. You will see the current formula I am using above, this is the...
This will likely be long winded, I apologize now. (some data removed and names changed for NDA reasons)
Basically I'm trying to sum these by the number in the middle, using the Plus/minus and Steak/Pastry/Apples. In the full dataset, the numbers in the middle repeat and are shared by pastry and...
I am using excel 2016 and trying to create ta formula that will return a certain value based on multiple criteria. I have set out the logic below but everything I try doesn’t work :mad:
Using VBA macro, Is there a way to copy the value in a cell from one workbook that has, ex, value is "X" in cell A2 workbook1 sheet 1 and paste that value into another workbook, but the pasted value is a Yes/No in cell A2 in workbook2 sheet1 if that cell is the value X?
Example shown below...
This is what I am trying to do. I have 4 core sheets that I input information into and it automatically calculates in the "monthly" and "quarterly" sheets. Right now, I place a tally mark in everyday the volunteer firefighter went to a call. Somedays they have one and some days they have five. I...
Unfortunately I can't get my XL2BB to run so apologies in advance for the screenshot.
I'm trying to calculate reducing balance depreciation in column M. I have split it out by month in columns O onwards, and I'm happy with how that works.
Ideally, I'd like to be able to calculate for...
Hello! I have an issue writing a formula that I hope has an easy response.
I have a dataset with people who have multiple rows of data relating to them. If a certain number of rows meet criteria (eg, are within a certain time period of each other), I would like Value Y on that row to be blank...
I am currently trying to use a formula range to automatically move along a column every month based on values up until the current month.
When a new month begins the formula should extend its range to the next new month and extend the sum. Each month ranges up to 4 years worth.
the error seems...
I've been given a task at work and am having a little bit of trouble with copying a countif formula.
The formula starts off as =COUNTIF($D$2:$D$885,"31/03/2017")
When I copy the formula I want the date associated with the formula to increase by one day each time. So the next...
I have a large inventory file I am working with. The data looks like this:
=IF(ROWS($A$28:A28)>COUNTIF(Utilisation!C62:C68,"Paid Breaks"),"",INDEX(Utilisation!A62:A68,SMALL(IF(Utilisation!C62:C68="Paid Breaks",ROW(Utilisation!C62:C68)-ROW(Utilisation!C62)+2),ROWS($A$28:A28))))
Is there any way to amend this formula so that it searches all of column "C" for the word...
I run a report that has a list of numbers, and only need the numbers below the 0's returned in a column or sheet. Here's what the final product should be:
Array forumla = =SUM(IF('Order Sheet'!$C$7:$C$19358>=Summary!B3,IF('Order Sheet'!$C$7:$C$19358<=Summary!C3,'Order Sheet'!$F$7:$F$19358)))
SUMIFs = =SUMIFS('Order Sheet'!F7:F19358,'Order Sheet'!C7:C19358, ">=B3",'Order Sheet'!C7:C19358, ">=C3")
I have two formula's one array, one a sumif. B3 &...
I've got a dataset with the following columns:
UniqueID | Date | Action
[Ex: U123 | 12/1/16 | purchased widget]
I need a formula to put in each row that will tell me what step it is for that unique id. I the example above, if "purchase widget" was the 5th thing U123 did, the formula would...
Hope someone can assist - I have the following formula which works perfectly to average the last 5 results of data in column D. Column D is a productivity rate and just a regular number
However, column C has one of 4...
I'm not overly sure how to explain this. I am creating a spreadsheet which has multiple sheets which has a summary sheet at the front which gathers data from all the different tabs. What is becoming a pain is having to rename the formulas to point to a particular tab, so, my question is...