| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Repeatability
I've used this formula to calculate the frequency of items being serviced in
many departments from another worksheet. There are 2 cells that won't give me the correct result. Please help. =SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="70223")) In Q1 70223 has 7 occurances which gives me a result of 7 from this SUMPRODUCT =SUMPRODUCT(('Q1 '!E13:E137="Calibrated")*('Q1 '!G13:G137="74532")) In Q1 74532 has 2 occurances, but the resultance is 0 (instead of 2) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct with Condition OR Sumproduct with ADDRESS function - HE | Excel Discussion (Misc queries) | |||
| Conditional SUMPRODUCT or SUMPRODUCT with Filters | Excel Worksheet Functions | |||
| Coefficient of Repeatability | Excel Worksheet Functions | |||
| How do I use Excel to do a Gage Repeatability and Reproducibility. | Excel Worksheet Functions | |||
| How do I calculate repeatability using Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
