-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
sumif based on selection
-
T
Formula to sum based on multiple criteria -For subscription revenues
Hello Excel Community, I was wondering if any of the amazing Excel masterminds can help me with a fomula based on several criteria. First I have a table with date which includes a customer ID, Customer Name, Type of Purchase, Date of Purchase, Start Date and End Dates of Purchase, the amount...- tarinann
- Thread
- 1/1/2018 1/1/2019 current date sumif based on selection
- Replies: 8
- Forum: Excel Questions
-
R
Flexible and conditional drop-down list
Hi everyone, I am working for a project for my company and would need some help on an issue I have. Ultimately, I want to create a model that is as flexible as a PivotTable without using a PivotTable. The reason for this that I won't be able to change any fields. I am working with...- rookie_excel
- Thread
- column drop-down drop-down list lists sumif based on selection
- Replies: 3
- Forum: Excel Questions
-
X
SumIF VBA Paste Values Help
Hello I'm new to using anything beyond simple copy paste functions in VBA. I want to do a sumif calculation using VBA where the output is values pasted in a defined range. The goal is to copy a values in range with a fixed set of dates to another range which has more dates but have those...- xaelic
- Thread
- copy & paste range sumif sumif based on selection vba
- Replies: 5
- Forum: Excel Questions
-
S
Sumif Sum Range to be a reference
Hi All, I have an indirect formula which works fine however I now need to make the SUM range dynamic as its basically summing a different date each week. <tbody> Name 06/10/16 (this date changes each week) David 8 (this is where the formula would be) </tbody> This is the formula...- stroffso
- Thread
- formula range sumif based on selection sumif based on variable week
- Replies: 3
- Forum: Excel Questions
-
R
Sum based on multiple criteria
Hi there, I am usually able to find the answer to my issue within the forum, however this time I am not sure if I have seen it or not...haha Here is what I am trying to do. I would like to summarize on a separate sheet, sales based on month and item. DataSheet <tbody> A B C 1 Date Item...- Rnelson333
- Thread
- match 2 criteria sumif based on selection
- Replies: 4
- Forum: Excel Questions
-
C
Sumif the difference between two columns for accounts listed in column x if the value is less than zero
Good Morning, I am trying to find if there is any way to use a sumif formula that will: SumIf the difference between Column C and Column B for all accounts in Column A that are in the list shown in Column D on another spreadsheet. I have used a sumproduct(sumif formula in order to sum the...- ChrisChee
- Thread
- sumif based on selection sumproduct sumifs
- Replies: 12
- Forum: Excel Questions
-
D
count and sum based on a date range
hi i would like to do some count and sum calculations based on a date value in a cell on the same row to be specific the spreadsheet is used to track the production of widgets. each line shows the detail including delivery date and qty of each order. i have a table set up showing the dates of...- dunst15
- Thread
- countif dates range select date range sumif based on selection
- Replies: 6
- Forum: Excel Questions
-
W
Using if statement to zero out a specific cell
Hello, I am trying to have a cell revert back to the number zero once the letter "Y" has been entered into another cell. For example, In B1 I have a very long "sumif" statement that searches for data below based on specific text in A1. It then returns the given total. In C1 I have a data...- wondmand
- Thread
- change to zero if statement sumif based on selection
- Replies: 4
- Forum: Excel Questions
