-
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 containing text
-
X
Sumifs for a forecast
Hi, So I am trying to create a weekly cash-flow forecast, that pulls data from another tab and using the expected payment date phases the income into the correct weeks by client. I have seen this done before but my formula is slightly off it seems. <tbody> A B C D E F G Cash flow Forecast...- xxkaykayxx
- Thread
- client forecast sumif sumif containing text sumifs between dates
- Replies: 3
- Forum: Excel Questions
-
A
Question using sumif
I am trying to have a summary page which will give me sales numbers for each year for 30 specific customers. I have a data sheet with all sales going back to 2010 that is arrange this way Column A - item Column B - Date Column E - Customer Name Column I - Amount the other columns are date I...- ajc623
- Thread
- sumif sumif containing text
- Replies: 7
- Forum: Excel Questions
-
J
Excel combination of SUMIF and SUBTOTAL while SUM of column based on the column TEXT
I have 1000+ rows in excel, in all rows of Column A there are only three texts that is "DEMAND" "COLLECTION" "BALANCE" I want to calculate the column F total based on the text of column A. for example 1 DEMAND 10 2 COLLECTION 20 3 BALANCE 50 4 DEMAND...- Jyotirmaya
- Thread
- sumif and subtotal sumif column contain sumif containing text
- Replies: 3
- Forum: Excel Questions
-
L
SUMIF Comparison Treats a Blank Cell on Subtotal Row as equal to a Text String Incorrectly
First let me describe my data. Columns A:V are in use and the data goes down just under 500 rows. The data represents income received on securities and is broken down by several data points such as account, security identifier, major industry name, minor industry name, etc. The data has been...- lmoseley7
- Thread
- sumif containing text
- Replies: 3
- Forum: Excel Questions
-
A
Identify group of cells with same reference and 1 cell in group = specific text
Hello, I'm not fab at excel, but know there is a formula for pretty much anything! So I'm hoping someone can help me. I have a spread sheet with a list of references in rows, 1 reference can be duplicated over a number of rows with a verity of status': Column A (Reference)_____________Column...- Abbyneedshelp
- Thread
- sumif containing text vlookup & if
- Replies: 3
- Forum: Excel Questions
-
T
Question on SUMIF vs SUMPRODUCT and how to return a total in one column based on values in other columns
I have a massive excel spreadsheet of data that contains thousands of URLS and web performance data. My table structure is: Col B = Microsite Col I = URLs Col S = Total Page Views I am trying get extract the total in range S3:S1048576 where the values in range B3:B1048576 = "xyz", and the...- TMCINNIS
- Thread
- sumif and countif sumif condition sumif containing text sumif formula sumproduct formula
- Replies: 29
- Forum: Excel Questions
-
B
How to sumif(s) using both date range and text
Hello, I am using a Google Spreadsheet to calculate total number of gift certificates sold by year AND (ideally) by gift certificate type (2 types: full or partial). An example spreadsheet with fake data is here...- bikes_212
- Thread
- sumif containing text sumifs sumifs for dates sumifs multiple criteria sumifs need help
- Replies: 2
- Forum: Excel Questions
-
L
sum column a if column b contains specific text
So I don't think there is a single formula to sum certain columns that contain specific text if that text is in a cell with other text, for example <tbody> A B $657.34 XX Oil company 234 $34.20 Gas $432.98 Car payment $653.97 Oil supplier $400.00 Oil $56.50 Gas $678.76 XX Oil...- Luigi802
- Thread
- containing text sum sumif sumif containing text
- Replies: 4
- Forum: Excel Questions
