Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
i...for the life of me can't get a sumproduct formula to work.
in a seperate worksheet i have column am. i want it to search column am for the number 3. after that i want it to go to column x and tell me how many of column am's number 3 have a y in column x. i'm using =SUMPRODUCT('Orders-Breakout'!AM:AM=3)*('Orders-Breakout'!X:X="Y") i keep getting a #num! error...what am i doing wrong? -- problem |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT not working. | Excel Worksheet Functions | |||
SUMPRODUCT not working. | Excel Worksheet Functions | |||
SUMPRODUCT not working | Excel Worksheet Functions | |||
Sumproduct not working | Excel Worksheet Functions | |||
Sumproduct Not Working | Excel Worksheet Functions |