sumproduct error

<tbody> This is my formula </tbody> =SUMPRODUCT(--('Trust Fund'!I:I="Q1Y18")*('Trust Fund'!$F:$F="Summary"),'Trust Fund'!$M:$M) I get the "Excel ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated." I:I is a drop down...

Hi Everyone, I have a large set of data in my excel spreadsheet with 9800 rows. I want use RANKIF function by comparing two columns. when I am trying to solve the problem using the below function =SUMPRODUCT(--(H2=$H$2:$H$9692),--(AZ2<$AZ$2:$AZ$9692))+1 it shows me a value error. I think due...

I need to sum the market values of a group of 11 stocks, identified by three letter tickers. I have three columns with data. Column A has 114 three-letter tickers, Column B has 114 market values associated with those tickers, Column C has the list of 11 tickers that I want a sum of market...

Hi all The formula =SUMPRODUCT(SUMIF(INDIRECT("'"&"Tabs"&"'!A:A"),$B$348,INDIRECT("'"&"Tabs"&"'!S:S"))) is not working, it returns #REF Tabs range is defined as =OFFSET('Tab List'!$A$1,0,0,COUNTA('Tab List'!$A:$A),1) Can I reference entire columns in SUMPRODUCT??? I have to do this really...

Hi, I have been using the following formula in a spreadsheet for a year now and today for some reason it is contantly throwing up the #value error. I have combed through the data it looks at several times today and so far can't find anything that would cause this error. The formula I'm using...