Good afternoon, I am currently trying to do the same function as =sumif(range,”Value”,range) for cells that contain text and have the text show as the value in the cell. Any help would be greatly appreciated, thanks
Good afternoon, I am currently trying to do the same function as =sumif(range,”Value”,range) for cells that contain text and have the text show as the value in the cell. Any help would be greatly appreciated, thanks
Since SUMIF returns numeric values....Can you post some sample data, what you want the formula to look for, and what value the formula should return?
That's very vague. Please attach a sample wrkbk or, at least describe the layout of the sheet. I.e., the cells/contents being examined and what you need from the formula.
Ben Van Johnson
I would like for it to look for "C" and return the data that is entered in the Cell, which will be an "Project Name", ie Excel Help Forum Building A.
Are you expecting to return a value from a single cell? This seems like a job for a lookup function rather than SUMIF. If you want to search for "C" in A1:A10 and return the corresponding value from B1:B10 try
=VLOOKUP("C",A1:B10,2,0)
It sounds like you need a lookup formula.
Example:
With this list in A1:B3
Please Login or Register to view this content.
and
D1: C
This formula returns the Project Name associated with the value in D1Please Login or Register to view this content.
In the above example, the formula returns: New Project.
Is that something you can work with?
Workbook layout is 45 individual sheets I am taking the values both numeric and alpha from 13 separate sheets to compile in to one sheet, I found that I can use the sum if for the numeric values for both ranges and single cells, to transfer the date by using =SUMIF('2008'!E5,"C",'2008'!P5), Yet I also need to sort the alpha values the same way to only be captured if it is “C”. I am not sure if I am explaining it correctly, but hopefully this will explain a bit better.
If you are only looking at a single cell perhaps you should use an IF formula, i.e.
=IF('2008'!E5="C",'2008'!P5,"")
This will work for both numeric and text values
Still confused.
1. You said:
It would help much if you would post a single sheet with representative data.Workbook layout is 45 individual sheets...
2. and:
SUMIF returns a "CONDITIONAL TOTAL". So, what do you mean when you say that you "transferred" data?...I found that I can use the sumif for the numeric values for both ranges and single cells, to transfer the date by using =SUMIF('2008'!E5,"C",'2008'!P5)...
3. finally:
Again, a workbook with, say, 25 - 30 rows of sample data (both "C" and "non-C") will help greatly....I also need to sort (??) the alpha values the same way to only be captured if it is “C”....
Last edited by protonLeah; 01-09-2009 at 05:35 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks