Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SUMIF
Hi,
1) Thanks to Tom Ogilvy who posted the earlier reply about the SUMIF function. This is what I was looking for, however it dosnt seem to handle text very well. What I want to do is to count the number of times a string appears in a column of data ( in a different workbook). However the way this string has been input means that there may be white space at the start or end of the string. Is there any way to get the SUMIF function to say IF A contains B, THEN ++ ?? ( as opposed to IF A = B). 2) Also is there anyway to work with spaces - I have a lot of worksheets to be referenced but they all contain spaces, and currnetly it wont let me work with these. 3) Is there any neat way of referencing the current sheet in a formula. See I have 2 Excel files, A , B. Both files have exactly the same number of worksheets ( each worksheet in A has a coressponding one in B, named identically). So what I want to do is to reference the coressponding worksheet in the other file from the current worksheet, without explicitly naming that worksheet ( so I can just copy it to all other worksheets - I will eventually have over 60 !! ) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF and IF | Excel Worksheet Functions | |||
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
nested sumif or sumif with two criteria | Excel Worksheet Functions | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |