formula to do a count for info in another column

[mike]

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

 

[Don Guillett]

=sumproduct((left(a2:a22,2)="IT")*1)

 

[Gord Dibben]

=IF(LEFT(A1,2)="it",1,"")


Gord Dibben MS Excel MVP

 

[mike]

thanks everyone! i appreciate the help!!!

=IF(LEFT(A1,2)="it",1,"")


Gord Dibben MS Excel MVP