Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel - Countif
I'm trying to use this formular to pull the count of items from another sheet
under 2 conditions: belongs to a department & being serviced. The sequence of "F2+Ctrl+Shift+Enter" would not get it to work, but it seems to work on the local sheet that carries the data, curiously, minus 1 count! =COUNT(IF(('Q3'!D12:D194,"=calibrated")*('Q3'!G12: G194,"=70223"),'Q3'!H12:H194)) Here's part of the sheet that I'm confused. Please help. Thanks. M702A calibrated 70222B $100.00 T-berd 310 calibrated 70222D $300.00 MP1570A OFR 8/6/2009 70222E $0.00 156 calibrated 70222E $364.59 T-Berd 310 calibrated 70223 $300.00 T-Berd 310 calibrated 70223 $300.00 T-Berd 310 ACTIVE 8/6/2009 70223 $0.00 T-Berd 310 calibrated 70223 $300.00 T-Berd 310 calibrated 70223 $300.00 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel percent using countif | New Users to Excel | |||
Excel 2000 - COUNTIF | Excel Discussion (Misc queries) | |||
Excel COUNTIF function | Excel Worksheet Functions | |||
COUNTIF or not to COUNTIF on a range in another sheet | Excel Worksheet Functions | |||
Excel countif and | Excel Discussion (Misc queries) |