| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUMPRODUCT question
I am trying to count based on multiple conditions. Here is a sample of my
table and the formula. {=SUMPRODUCT((A2:A22="1188")*(B2:B22="Feb"))} A B 1188 Feb 1188 Apr 1213 May 1188 May 1259 Mar 1188 Mar 0994 Jun 1188 Jun 0994 Jul 1188 Jun 0993 May 1188 Jun 1188 Feb It returns a value of "0". Please help. Thanks, PFAA |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct Question #1 | New Users to Excel | |||
| Sumproduct question | Excel Discussion (Misc queries) | |||
| Sumproduct question? | Excel Discussion (Misc queries) | |||
| SumProduct Question | Excel Discussion (Misc queries) | |||
| SUMPRODUCT question | Excel Worksheet Functions | |||
Threaded Mode
