=SUMPRODUCT((Data[Column1]=TRUE)*(Data[Counts of Assets in BU])*(Data[Region]=A17))
I have the above formula but for some reason is returning as #VALUE !
Not sure what i did wrong
I just need the formula that if column1 is true in the sheet data and Region in sheet Data matches region in A17...
=SUMPRODUCT((Raw Data[Count of Assets in BU)*(Raw Data[Column1]=TRUE))
Something is wrong with the formula, what i need is to place the formula in the calculation tab that if header Column1 is true, sum the header Count of Assets in BU that meet the true criteria
hello All....
I have an excel input form where the user enters a WORKORDER NUMBER (WONUM) and Asset assigned. Most of the time there will be multiple assets per wonum, each of these assets are a separate entry.
What I'm trying to accompish:
I want a text box that will list these assets in a...
Hello, I need some help
I have a worksheet called data weekly.
C4 to C108 are the date. (C4 = 2017/06/23)
D3 to AA3 are the assets.
D4:AA108 are the index of those assets.
I want to convert those data into monthly data in another worksheet called data monthly VBA.
(start from D4) C4=...
To whom might be able to help.
In the example above location 1 fulfill their 50000 lbs delivery with the first two assets. Would like to modify algorithm so that location 2 is fulfilled with the next available asset (right now starts again with the same assets) and on to the next location so...
Hi, first time poster here...go easy! LOL
I have a spreadsheet and in the asset column i have a list of numbers related to that one line of information. All separated by a comma
<tbody>
Number
Title
Rev
Asset
total amount of assets
UC02-WPD-UT-REP-N001-000012
Network Design - N1
P01...
Hello excel community
I am new to the forum and a newby to excel. I know stuff but when complicated tasks as this pop up, seeking help is inevitable.
Namely I need to show the price changes of assets over a certain period of time.
I have been provided with a table where i have all the assets...
I am trying to insert a row above the cells that have text values that begin with the word "ASSET", and the same thing for "Income".
I've got my code below working up to a point
It inserts the row above ASSETS and INCOME correctly
then I want to select cells (B?:D?") to format those 3 cells in...
All,
Could any body help me? im struggling to overcome a problem :) please see the linked spreadsheer (you don't have to activate macros, they're just used for adding new rows - hopefully ill dev this into a userform interface)
We have a 'required quantity' column which is the exact amount we...
Hi All,
I was asked to prepare an excel file that is able to calculate maximum proceeds from an auction of multiple assets. In short, company is liquidating all assets in a court process and we must track bidders for all assets. Some bidders will bid for entire assets while other bidders will...
Hi All,
The following formula returns a 0 value, but the second formula works. The only difference is that the first index column has been changed only to column D, and the same with the second match function.
The answer I am looking for is in column D, but i would like to drag the formula...
Hello Board,
I have this formula....
=SUM(COUNTIFS('Assets Open'!$N:$N,">="&U3-6,'Assets Open'!$N:$N,"<="&U3,'Assets Open'!$K:$K,{"john*smith",""}))
It counts in the sheet name Assets Open in column N and cell U3 >= -6 and cell U3 <= it counts all the john smith and any blank cells.
the...
hi all,
i have a code snippet which seems to run slow, any way to improve this code and add in worksheet unprotect for each ws in array and then reprotect each ws once columns are hidden?
Application.ScreenUpdating = False
Dim Assets As Variant
Dim Asset As Variant
Dim ThisSheet As...
Hello board,
I have this formula....
=COUNTIFS('Assets Open'!$N:$N,">="&W3 -6,'Assets Open'!$N:$N,"<="&W3 +1,'Assets Open'!$K:$K,"john*smith")
It works great. But I want to add another criteria in the same column K:K
So it will search for a blank cell in addition to john smith.... count...
Hi guys
So I have made an excel document containing the price of an asset on two different exchanges, i have a query set up so that it gets the information from the server and automatically update the two cells every minute, that all works fine. However I would like to plot the change in the...
Hi All, I have a number of assets at a number of locations. Assets are sometimes added, moved, or removed. We have a master tracking list with the location of each asset. I have a maintenance tracking list that I would like to have update automatically from the master list. All the data is in...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.