Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Countif question
=SUMPRODUCT(--(Test!$G$26:$G$39=$A2),--(Test!$F$26:$F$39=0))
Replace Test! with Sheet1! "Jim" wrote: Hello and thanks for the help. Sheet one is my data dump. The data I dump into this sheet will look like this: A B C Sales Rep 1 126.84 Store 1 Sales Rep 1 0 Store 2 Sales Rep 1 48.25 Store 3 Sales Rep 1 59.97 Store 4 Sales Rep 1 319 Store 5 Sales Rep 1 40.66 Store 6 Sales Rep 2 0 Store 7 Sales Rep 2 122.98 Store 8 Sales Rep 2 29.55 Store 1 Sales Rep 2 69.97 Store 2 Sales Rep 2 0 Store 3 Sales Rep 2 146.09 Store 4 Sales Rep 2 17.63 Store 5 Sales Rep 2 119.87 Store 6 Sheet two is my report: A B C D E Store Sales Service Total $0.00 Orders Store 1 58 106 164 0 Store 2 42 50 92 0 Store 3 137 234 371 0 Store 4 22 89 111 0 Store 5 112 148 260 0 Store 6 129 148 277 0 Store 7 103 156 259 0 Store 8 83 141 224 0 I would like to count the number of times 0 appears in sheet one and match that 0 by store to the report on sheet two. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I have a question regarding countif formula. | Excel Worksheet Functions | |||
countif question | Excel Worksheet Functions | |||
countif question using 2 conditions | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions | |||
COUNTIF Question | Excel Worksheet Functions |