| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create Pivot Table Data with Column "Sum" rather than "count" defa | Excel Discussion (Misc queries) | |||
| Pivot (Data Items "Count" vs "Sum") | Excel Discussion (Misc queries) | |||
| How do I move a document from "recent items" to "documents" | New Users to Excel | |||
| How to Count the number of "rows" (or Array items) included in a Sumif formula? | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
