I gather data relating to processed items which comes from an online database. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o></o>
The system produces accepted and declined items. The accepted items have a 0 in Cell R where as the declines have 04 . I used the SUMPRODUCT formula =SUMPRODUCT(--(L181),--(R181=0)) to work out if the item had been accepted, if so the so value of the item would be returned.<o></o>
<o></o>
My issue now is that the online database requests me to convert the data to a blank excel document, to which intern I have to copy and paste into my excel work book. When doing this the SUMPRODUCT formula will no longer pick up the 0, and so no value is returned when required. <o></o>
<o></o>
Does anyone no if this seemingly simple issue can be resolved, or will i have to copy the data into an database to reformat??
Any helpful guidance is much appreciated
fficeffice" /><o></o><o
></o>The system produces accepted and declined items. The accepted items have a 0 in Cell R where as the declines have 04 . I used the SUMPRODUCT formula =SUMPRODUCT(--(L181),--(R181=0)) to work out if the item had been accepted, if so the so value of the item would be returned.<o
></o><o
></o>My issue now is that the online database requests me to convert the data to a blank excel document, to which intern I have to copy and paste into my excel work book. When doing this the SUMPRODUCT formula will no longer pick up the 0, and so no value is returned when required. <o
></o><o
></o>Does anyone no if this seemingly simple issue can be resolved, or will i have to copy the data into an database to reformat??
Any helpful guidance is much appreciated
