Need a formula please

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 cells
Thanks Ron J

See More: Need a formula please

Report •


#1
June 11, 2009 at 19:00:40
I need some clarification.

re: If in cells E8 to E107 the word FMC is entered

In every cell in E8:E107 or in any cell in E8:E107?

re: sum the cells B8 to B107 and as well C8 to C107

Should 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:E107

and

The formula needs to return the sum into one cell

Thanks


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 •


Ask Question