sumif column contain

Hello everyone. I have written the formula as seen below and works like that: In the A6:A35 is looking for the codes that have as a 7th and 8th letters "CN" and then in the B6:B35 is looking for "Reliable". Then for the month August (j6:j35) it sums the amounts for the above criteria. What I...

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...

Hello, I am working with two tables (both shown below). I want to be able to populate Column B in Table 2 by writing a lookup (I assume it's a variation of SUMIF) that will look at the value in Table 2, Column A, match it with the first five characters in Table 1, Column A, and sum the values...

Hi guys, I'm having issues getting my head around a formula and wondered if you could help me before I throw my PC out of a window! I do not like excel 2003 at all! I'm working across 2 spreadsheets, for arguments sake we'll call them S1 and S2. The result i need from a formula is as follows...

I've come quite far with our new excel sheet, mainly because of the tips on this forum; but now we are a little stuck.. I've made a little example of our spreadsheet (only the important fields): <tbody> Posting Total B003 20 B004 10 B005 20 B100 5 B101 20 C100 16 C101 21 C102...

When you filter a spreadsheet, you can find results that are similar to a condition. I have families of products that share a common 3 digits, but the rest of the model number is different. The 3 similar digits could be the first 3 digits, or it could be 3 digits starting with the 2nd digit...

Hi, I have over 8000 line excel report which lists all items in a quotes. I need to add column for "Extended List Price" only for the lines that are for the same quote Example: I need for the code to be able to scan my report and average the discount % but only for the same quotes . Currently...

All, Thank you for your time for looking at my question. I would like to count the # of consecutive cells in a column that have a zero in them if there are more than 10 consecutive cells with a value of zero. For example, I have a spreadsheet that records production data from a machine. Each...

Hi, Can somebody please help me? I have a worksheet that I need to sum information in column B nased on partial information in column A. Ex: <TABLE style="WIDTH: 280pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=374><COLGROUP><COL style="WIDTH: 48pt" width=64><COL...

Hi Is there an easy way to sum all cells in a column where the cell to it's immediate left contains "AB"? Perhaps something like this: =SUMIF(B1:B5,A1:A5="AB") <TABLE style="WIDTH: 70pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=94><COLGROUP><COL style="WIDTH...