Home |
Search |
Today's Posts |
#1
|
|||
|
|||
3-D formulas... can it work for text too?
Can the 3-D formula be used for finding text?
I'm trying to incorporate it into the =countif function, but I just get errors. Or is there another way to count the # of cells (1 per page) that have a specific text in them? The cells are in the same position on all pages to be looked at. |
#2
|
|||
|
|||
Here's an example:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Sheet1","Sheet2 ","Sheet3"}&"'!A1"),"apple")) Here I want a total count of the word "apple" appearing in A1 of Sheet1, Sheet2, and Sheet3. HTH Jason Atlanta, GA "Xanadude" wrote: Can the 3-D formula be used for finding text? I'm trying to incorporate it into the =countif function, but I just get errors. Or is there another way to count the # of cells (1 per page) that have a specific text in them? The cells are in the same position on all pages to be looked at. |
#3
|
|||
|
|||
"Jason Morin" wrote: Here's an example: =SUMPRODUCT(COUNTIF(INDIRECT("'"&{"Sheet1","Sheet2 ","Sheet3"}&"'!A1"),"apple")) Here I want a total count of the word "apple" appearing in A1 of Sheet1, Sheet2, and Sheet3. HTH Jason Atlanta, GA "Xanadude" wrote: Can the 3-D formula be used for finding text? I'm trying to incorporate it into the =countif function, but I just get errors. Or is there another way to count the # of cells (1 per page) that have a specific text in them? The cells are in the same position on all pages to be looked at. Thanks, but I had already figured out another method of doing it. Since all cells looked at will have the same text - it's just a matter if they have the cell marked or not, I get the proper answer with the following: =counta(Sheet1:Sheet3!A1) The problem I was having was inserting a , (comma) into the formula after the ! sign. Why it doesn't tell me that when the error message pops up, I don't know. That's what I get for working at 6:00 am LOL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I get EXCEL formulas to work in Works? | Excel Worksheet Functions | |||
Correct formulas in cells, have to retype to work | Excel Discussion (Misc queries) | |||
How come my formulas work in one cell but not the other? | Excel Worksheet Functions | |||
How can I work around the non value (#N/A) when using formulas in. | Excel Worksheet Functions | |||
Formulas do not work in excel. | Excel Discussion (Misc queries) |