count of items that results from two "IF" statements
 

I am trying to create a count of items. I have a column of item names and
next to each is a true/false column to verify whether it gets counted or not.
I want to get a total number of each item that has the true flag next to it.

count of items that results from two "IF" statements
 

=SUMPRODUCT(--(A1:A100="item_name"),--(B1:B100=TRUE))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"johnsonconsulting" wrote in
message ...
I am trying to create a count of items. I have a column of item names and
next to each is a true/false column to verify whether it gets counted or
not.
I want to get a total number of each item that has the true flag next to
it.