| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add amount if record contains a value
Hello,
I want to add the amount based on column A if the text in A contains *88B and my data looks like this Sheet1 A B C AI 1088B AA886 2500 KA1088B AA886 3000 AAA1088B AA886 1000 Sheet2 A B C AAA1088B AA886 The formula is in Sheet2 column C. I used this formula but it returned FALSE =IF(MID(A1,6,2)=MID(A1,6,2),SUMPRODUCT((A1:B17),G1 5:G17)) Please help. Thanks Bexi |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Record data on two lines | Excel Discussion (Misc queries) | |||
| Can't go to 'Last Record' in one step in a Word doc. linked To Exc | Excel Discussion (Misc queries) | |||
| formula to calculate a benefit amount | Excel Discussion (Misc queries) | |||
| Referencing a newly created worksheet | Excel Worksheet Functions | |||
| Restrict input if amount is exceeded | Excel Worksheet Functions | |||
Threaded Mode
