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

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

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

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