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

I need some clarification. re:

If in cells E8 to E107 the word FMC is enteredIn

everycell in E8:E107 or inanycell 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?

If FMC is placed in any cell in E8:E107 and

The formula needs to return the sum into one cell

Thanks

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),"")

With a little further thinking I've worked the problem out so thanks very much for your assistance. Regards Ron :-)

Ask Your Question

Weekly Poll

Would you ride in a self-driving car from Tesla?

Discuss in The Lounge

Poll History