Prev: Synchronous scrolling in all sheets of a wokbook.
Next: Working from oldest date
From: "Bernie Deitrick" deitbe on 9 Sep 2009 09:28
goonie,

Select each of the ranges (outlook!CV2:CV1931, etc), then use Edit / Go To... Special Formulas
uncheck all but "errors" and press OK. That will select your cells with errors. Or use data
filters on the ranges, and select the error values from the dropdown to show just those cells.

HTH,
Bernie
MS Excel MVP


"goonie" <goonie(a)discussions.microsoft.com> wrote in message
news:5AB995FE-828E-458D-A267-AE67946D6C57(a)microsoft.com...
> The sumproduct formula that I'm using is returning #div/0!.
>
> Here's the formula: =SUMPRODUCT((outlook!CV2:CV1931="XNOR
> OPC")*(outlook!CU2:CU1931="jpy")*outlook!CD2:CD1931)
>


From: Max on 9 Sep 2009 10:08
Welcome, glad to hear ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"goonie" <goonie(a)discussions.microsoft.com> wrote in message
news:29ECD1D3-B26E-4726-8E87-397B8EB24C11(a)microsoft.com...
> Thank you so much - It was driving me crazy! The formula always worked
> before
> and now it does again!!!!


First  |  Prev  | 
Pages: 1 2
Prev: Synchronous scrolling in all sheets of a wokbook.
Next: Working from oldest date