Sumproduct

[Magee]

Hi Guys,

I'm probably know this is not possible, but would ask the experts anyway.

I have the following sumproduct formula that interegats a list and brings back a number that meet the criteria.

=SUMPRODUCT(--(Sales!$A$2:$A$99999>0),--(Sales!$J$2:$J$99999='New Vehicle Stock Analysis'!D$8),--(ISNUMBER(SEARCH(A13,Sales!$C$2:$C$99999))),--(ISNUMBER(SEARCH(B14,Sales!$C$2:$C$99999))))

Question - Am I able to double click the cell (or something like that) to display the returned data?

Thanks for your help

 

[Andrew Poulsom]

Sorry, no. You can evaluate the formula under Tools|Formula Auditing, but you won't see much given the size of the referenced ranges.

 

[Magee]

thought so. thank you for your response Andrew.