E
Eric Garcia
I am trying to use sumifs to gather information if one of two tests
are true. I would like to be able to make a purchase apear as
executed if Employee 1 (Column N) or Employee 2 (Column O) has
selected Executed from a multiple option list on a form I am exporting
to Excel. I have tried using the OR function, but it won't sum a
logical function, just give me true or false. I know how to do this
if I create an extra hidden line in the table, but I would prefer to
not have to do that. If I were to ask excel to make this calculation
I would say to it "Add the price/cost of all purchases for this
ACCOUNT, match them with the ITEMS that match this line item, and
place it in the Exectued Column if either Employee 1 (Column N) or
Employee 2 (Column O) selects EXECTUED. I will list the code I have
below replaceing cell names with the terms i used above. The problem
with this code is both employees have to select executed, and I want
only on of the two people to have to select executed.
=SUMIFS(Price/Cost(Column L),Column E,Account,Column C,Item,Employee1
(Column N),Executed,Employee 2(Column O),Executed)
I apologize if this is confusing, or if I am missing a very simple
fix. I am not yet an Excel Ninja, so I am looking to those who are to
give me some guidance on my path to Enlightenment
are true. I would like to be able to make a purchase apear as
executed if Employee 1 (Column N) or Employee 2 (Column O) has
selected Executed from a multiple option list on a form I am exporting
to Excel. I have tried using the OR function, but it won't sum a
logical function, just give me true or false. I know how to do this
if I create an extra hidden line in the table, but I would prefer to
not have to do that. If I were to ask excel to make this calculation
I would say to it "Add the price/cost of all purchases for this
ACCOUNT, match them with the ITEMS that match this line item, and
place it in the Exectued Column if either Employee 1 (Column N) or
Employee 2 (Column O) selects EXECTUED. I will list the code I have
below replaceing cell names with the terms i used above. The problem
with this code is both employees have to select executed, and I want
only on of the two people to have to select executed.
=SUMIFS(Price/Cost(Column L),Column E,Account,Column C,Item,Employee1
(Column N),Executed,Employee 2(Column O),Executed)
I apologize if this is confusing, or if I am missing a very simple
fix. I am not yet an Excel Ninja, so I am looking to those who are to
give me some guidance on my path to Enlightenment