| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question re COUNTIF function - reading data from a differnet sheet
=COUNTIF(
then with the cursor after the first parenthesis select the range on the other sheet with your mouse -- Regards, Peo Sjoblom "Mighty Magpie" <mighty.magpie@home wrote in message ... Hello If I use the following formula I sort of get what I want but I would like to put the formula onto a sheet named "LIST" and for it to find the information from a different sheet (named DATA) =COUNTIF(E2:E50000,I2) Can someone please advise me how to do this? TIA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A question about the Count/CountIf function | Excel Worksheet Functions | |||
| Reading data from another sheet where data is in variable cells | Excel Discussion (Misc queries) | |||
| How do I display this data in a differnet format? | Excel Discussion (Misc queries) | |||
| CountIf Function Question | Excel Discussion (Misc queries) | |||
| Countif/Sumif function question | Excel Worksheet Functions | |||
Threaded Mode
