LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default sumproduct not working

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT not working. Gaurav[_4_] Excel Worksheet Functions 2 June 25th 09 09:37 PM
SUMPRODUCT not working. Nde Excel Worksheet Functions 2 October 16th 07 09:19 PM
SUMPRODUCT not working Ang Excel Worksheet Functions 7 April 28th 07 07:32 AM
Sumproduct not working macamarr Excel Worksheet Functions 5 December 28th 06 02:36 PM
Sumproduct Not Working Carl Excel Worksheet Functions 5 August 15th 06 07:09 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"