Replies

scanpst.exe will (I assume) do the same. It’s cleaned out ghost appointments for me in the past.

Yes, within limits. For example you can’t use a boolean formula dynamically; sumif will just match against the formula result, and so will sum only values which are true, or false, or 1, or zero.

You can use sumif directly where the external reference is a straight match; where cell a1 contains UT, the comparison range contains US States, and the data range is numbers, =sumif(comparison_range,a1,data_range) will sum all numbers for UT.

And you can use sumif with externally referenced arguments using a little string formula to create a boolean; where cell a1 contains a variable to search against, you can use
=sumif(comparison_range,”<"&a1,data_range)

Care to post an example of what you want?

The SUMIF function adds a range of data if data within that range or a corresponding range satisfies a condition.

I run OL98 on W95, so your mileage may vary, and this may be a hemi-gluteal answer anyway.

Try setting up an offline folder (*.OST) on each machine, and move your PST contents to the network and both the machines.

=SUMIF(range,”>=1″)

Glad to help. Note that if your indirectly referenced spreadsheet has a space in the name, the indirect reference will need to be built as
‘my name’!rc
as opposed to
myname!rc
where rc are the row and columns refs

It’s a little unclear what you want. Do you want a text result such as, where d1 contains the spreadsheet name and d2 contains the date:
=D1&” “&TEXT(D2,”mm/dd/yyy”)

or do you want a formula which refers to a cell in that other spreadsheet, depending on which spreadsheet is named, such as, where d1 contains the spreadsheet name and d3 in that other spreadsheet contains the value you want to reference:
=INDIRECT(“‘”&D1&”‘!”&”d3”)

I’m a registered Opera 4 user and occasionally it falters on some java, shockwave and flash, etc., implementations. (Perhaps I’m not installed correctly, but I think I am.) For example it doesn’t show everything on Bolle’s (overdesigned) website, and I’ve had other problems. Otherwise, faster than a speeding bullet, more streamlined than a starving weasel, support facilities appear excellent but I haven’t tested them.