| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumproduct formula problem
I am trying to try and find the sumproduct of two names in a column P to
who are still waiting appt.showing in column Q The formal i am using is only giving a 0 fig. I do know that there are 25 waiting. Can you tell me to where i going wrong or using the formula. Again thanks for your assistance i think this is great web sight as i have used it many times. =SUMPRODUCT(('Nov 07'!P27:P52="Alcohol Leek"" Concern Other Leek")*('Nov 07'! Q27:Q52="Waiting Appt")) -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200711/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with SUMPRODUCT formula | Excel Worksheet Functions | |||
| Problem with SUMPRODUCT formula. | Excel Discussion (Misc queries) | |||
| Problem with a SUMPRODUCT Formula | Excel Worksheet Functions | |||
| Problem w/ A Sumproduct Formula | Excel Worksheet Functions | |||
| Sumproduct / Max array formula problem | Excel Worksheet Functions | |||
Threaded Mode
