sumif help
 

I have a simple sumif formula which I can't get to sum. My current formula is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x
in it; if it does I want to add the values in cells F3 and G3. Now all this
formula does is check for the x in M3 and puts the F3 value in the cell. It
doesn't add F3 and G3.

Jim

sumif help
 

One way:

=(M3="x")*(F3+G3)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jim" wrote in message
...
I have a simple sumif formula which I can't get to sum. My current formula
is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an
x
in it; if it does I want to add the values in cells F3 and G3. Now all
this
formula does is check for the x in M3 and puts the F3 value in the cell.
It
doesn't add F3 and G3.

Jim

sumif help
 

Thanks that worked!

"RagDyer" wrote:

One way:

=(M3="x")*(F3+G3)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jim" wrote in message
...
I have a simple sumif formula which I can't get to sum. My current formula
is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an
x
in it; if it does I want to add the values in cells F3 and G3. Now all
this
formula does is check for the x in M3 and puts the F3 value in the cell.
It
doesn't add F3 and G3.

Jim

sumif help
 

More straightforward:
=IF(M3="x",SUM(F3:G3),0)

"Jim" wrote:

I have a simple sumif formula which I can't get to sum. My current formula is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has an x
in it; if it does I want to add the values in cells F3 and G3. Now all this
formula does is check for the x in M3 and puts the F3 value in the cell. It
doesn't add F3 and G3.

Jim

sumif help
 

Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Jim" wrote in message
...
Thanks that worked!

"RagDyer" wrote:

One way:

=(M3="x")*(F3+G3)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jim" wrote in message
...
I have a simple sumif formula which I can't get to sum. My current
formula
is
=SUMIF(M3,"x",F3:G3). What I want to do is check to see if cell M3 has
an
x
in it; if it does I want to add the values in cells F3 and G3. Now all
this
formula does is check for the x in M3 and puts the F3 value in the cell.
It
doesn't add F3 and G3.

Jim