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

Why is this formula below not working as is?

If I remove either one of the conditions =$b$4 or <$b$5 it produces a value
but both conditions together it gives me 0 which is incorrect

Note: both b4 and b5 are '1000 and '1099 respectively


=SUMPRODUCT((ISNUMBER(MATCH('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$A$3:$A$277,$A12:$B12,0)))*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1=$B$4)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$1:$CI$1<$B$5)*('[YTDTB ACTUAL
''09-10.xls]YTDTB99'!$D$3:$CI$277))

Thanks
 
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 Curtis Excel Worksheet Functions 3 November 4th 09 02:16 AM
SUMPRODUCT Not Working dj479794 Excel Discussion (Misc queries) 2 March 12th 07 12:54 PM
sumproduct not working Tester Excel Worksheet Functions 10 November 26th 06 09:58 PM
Sumproduct Not Working Carl Excel Worksheet Functions 5 August 15th 06 07:09 PM
sumproduct not working BorisS Excel Worksheet Functions 3 March 6th 06 08:21 PM


All times are GMT +1. The time now is 04:23 AM.

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"