June 11, 2009 at 18:35:22
Specs: Windows XP
 I'm trying to write a formula in excel that says:-If in cells E8 to E107 the word FMC is entered then sum the cells B8 to B107 and as well C8 to C107 which represent hours and minutes in those cellsThanks Ron J

See More: Need a formula please

#1
June 11, 2009 at 19:00:40
 I need some clarification.re: If in cells E8 to E107 the word FMC is enteredIn every cell in E8:E107 or in any cell in E8:E107?re: sum the cells B8 to B107 and as well C8 to C107Should this SUM be in 1 cell or 2 cells?

Report •

#2
June 11, 2009 at 19:08:25
 If FMC is placed in any cell in E8:E107andThe formula needs to return the sum into one cellThanks

Report •

#3
June 11, 2009 at 19:22:21
 This is what you asked for, but I'm not convinced it's what you really want. =IF(COUNTIF(E8:E107,"=FMC")>0,SUM(B8:B107,C8:C107),"")

Report •

Related Solutions

#4
June 11, 2009 at 21:03:01
 With a little further thinking I've worked the problem out so thanks very much for your assistance.Regards Ron :-)

Report •