LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Josh O.
 
Posts: n/a
Default SumProduct help

I have the following formula: =SUMPRODUCT(--('Tab 2'!E3:E50='Tab
1'!D1),--('Tab 2'!C3:C50='Tab 1'!A6),Tab 2'!I3:I50)

I need to change the first criteria to equal 'Tab 1!D1 or D2, but I don't
know exactly how to change the formula. The result needs to sum the values
in I3:I50 that also have values in column C that equal A6 and values in
column E that equal D1 or D2.

I hope I made that clear enough.
 
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
Another Sumproduct & #N/A problem Dave Davis Excel Worksheet Functions 3 January 10th 05 03:59 PM
Sumproduct - multiple criteria in Column A briank Excel Worksheet Functions 2 January 6th 05 06:44 PM
Sumproduct ... Empty Cells vs Spaces? Ken Excel Discussion (Misc queries) 9 December 17th 04 08:03 PM
Sumproduct function not working Scott Summerlin Excel Worksheet Functions 12 December 4th 04 05:15 AM
adding two sumproduct formulas together ski2004_2005 Excel Worksheet Functions 1 November 12th 04 09:08 PM


All times are GMT +1. The time now is 06:50 AM.

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

About Us

"It's about Microsoft Excel"