Need another formula

L

Lee

Ok, I'm using the formula =SUMIF(B1,"=X",A1) to show the value of cell A1
only if cell B1 has an "X". I want to include the value of 2 other cells
along with cell A1 but only if cell B1 has the "X".
 
J

joeu2004

Lee said:
Ok, I'm using the formula =SUMIF(B1,"=X",A1) to show
the value of cell A1 only if cell B1 has an "X".
Click to expand...

First, why would you use SUMIF() for this purpose? That's
like "killing an ant with a sledgehammer". Why not simply
one of the following?

=if(B1 = "X", A1, 0)
=(B1 = "X")*A1
I want to include the value of 2 other cells along with cell
A1 but only if cell B1 has the "X".
Click to expand...

Will one of the following fit the bill?

=if(B1 = "X", sum(A1:A3), 0)
=if(B1 = "X", A1+A3+A5, 0)
=(B1 = "X")*sum(A1:A3)
=(B1 = "X")*(A1+A3+A5)
 
L

Lee

Thanks. That worked perfectly.
--
Lee Davenport


[email protected] said:
First, why would you use SUMIF() for this purpose? That's
like "killing an ant with a sledgehammer". Why not simply
one of the following?

=if(B1 = "X", A1, 0)
=(B1 = "X")*A1


Will one of the following fit the bill?

=if(B1 = "X", sum(A1:A3), 0)
=if(B1 = "X", A1+A3+A5, 0)
=(B1 = "X")*sum(A1:A3)
=(B1 = "X")*(A1+A3+A5)
Click to expand...
 
Top