Thread: If statement - begins with
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default If statement - begins with
try
=sumproduct((left(a2:a22,1)="b"),c2:c22)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"grantr" wrote in message
...
Anyone know how to create an if statement that would say, if any cells in
the
column begin with B, sum the values in the column next to them.
--
grantr

Reply With QuoteReply With Quote