| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to do a count for info in another column
Hi,
If column A row 1 has the text "IT-MDU" how can I in column B write a formula to state that if the 1st 2 letters in column A are "IT" = 1 and if not ""? I want to import this information to Access to create a report and I need to know everything in IT development and I would ask access to do a count of column B to let me know but I need to be able to populate it in Excel 1st. Mike |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to do a count for info in another column
=sumproduct((left(a2:a22,2)="IT")*1)
-- Don Guillett Microsoft MVP Excel SalesAid Software "mike" wrote in message ... Hi, If column A row 1 has the text "IT-MDU" how can I in column B write a formula to state that if the 1st 2 letters in column A are "IT" = 1 and if not ""? I want to import this information to Access to create a report and I need to know everything in IT development and I would ask access to do a count of column B to let me know but I need to be able to populate it in Excel 1st. Mike |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to do a count for info in another column
=IF(LEFT(A1,2)="it",1,"")
Gord Dibben MS Excel MVP On Wed, 24 Dec 2008 10:15:02 -0800, mike wrote: Hi, If column A row 1 has the text "IT-MDU" how can I in column B write a formula to state that if the 1st 2 letters in column A are "IT" = 1 and if not ""? I want to import this information to Access to create a report and I need to know everything in IT development and I would ask access to do a count of column B to let me know but I need to be able to populate it in Excel 1st. Mike |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to do a count for info in another column
thanks everyone! i appreciate the help!!!
"Gord Dibben" wrote: =IF(LEFT(A1,2)="it",1,"") Gord Dibben MS Excel MVP On Wed, 24 Dec 2008 10:15:02 -0800, mike wrote: Hi, If column A row 1 has the text "IT-MDU" how can I in column B write a formula to state that if the 1st 2 letters in column A are "IT" = 1 and if not ""? I want to import this information to Access to create a report and I need to know everything in IT development and I would ask access to do a count of column B to let me know but I need to be able to populate it in Excel 1st. Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update column info based on column info from another worksh | Excel Discussion (Misc queries) | |||
| How do I add further info into a column containing a formula | Excel Worksheet Functions | |||
| Using a date range in a formula to pull info to the correct column | Excel Worksheet Functions | |||
| How do I count something in one column = to info in another | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Hybrid Mode
