Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

Need a formula please

Comment:

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

Name: DerbyDad03
Date: June 11, 2009 at 19:00:40 Pacific

Reply:

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?

0

Reply:

If FMC is placed in any cell in E8:E107 and The formula needs to return the sum into one cell Thanks

0

Name: DerbyDad03
Date: June 11, 2009 at 19:22:21 Pacific

Reply:

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

0

Reply:

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

0

Excel Database

Can't receive email

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Thanks for the input, it's always hard to ask a question on a forum that everyone understands. I have a worksheet named test1. Next, I'll make a worksheet named test2. I'm making both of these from a ...

Summary: You can write a formula (called "mySum" in my example) with Visual Basic in Excel: 1) Open the VBE by clicking Tools / Macros / Visual Basic Editor 2) In the VBE window, click Insert / Module 3) P...

Summary: Folks, I'm in a bind here. I'll spare you the details, but I need a copy of a file..can't find the one I need. It's an Office 2003 SP2 file named mainsp2.msp. Does anyone have that? If so, could yo...