Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Countif accross multiple questions.
Hi folks,
I know this has been asked and answered, but I could not get it working. I thought I would ask my specific problem. I have a excel spreadsheet with a detail sheet containing columns. One column is Inventoried whose values are TRUE or FALSE. Another column is PRICE which could be 0 or any number like 5.35. In anoher sheet I want a summary. I have one cell that is inventoried (=COUNTIF('INVENTORY'!E:E,"TRUE" I need another Cell that will be Unpriced inventory which is the number if Inventoried = 'TRUE' and price = 0. I tried the sumproduct but keep getting errors. I have thought of adding additional columns, but would prefer not to if possible. Any help would be greatly appreciated. Thanks, |
#2
|
|||
|
|||
Countif accross multiple questions.
Did you use double unary operators in the SUMPRODUCT formula? I got
this one to work: =SUMPRODUCT(--(D1:D5=TRUE),--(E1:E5=0)) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple COUNTIF formula | Excel Discussion (Misc queries) | |||
COUNTIF - multiple conditions | Excel Worksheet Functions | |||
multiple conditions in COUNTIF (Excel 2000) | Excel Discussion (Misc queries) | |||
Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions |