General

sumif on a single criteria rows but several sum rows
This sounds simple but is proving tricky I have row of booleans a1:l1 and want to sum rows below that a3:l7 according to the booleans value, but how could this be done in 1 cell sumif wont work because the ranges are different shapes so it only does row 3. I think the problem is row/column ambiguity ... 9 Jul 2008 08:33

Email data from a form
I use a UserForm to enter data into an Excel list (database). How do I email the data in the form prior to saving it to the list (or after, assuming the data stays on the form). Thanks, Rob L ... 9 Jul 2008 06:31

Relative references in conditional formats
It is good that Excel 2007 has the feature of Contional Format manager. However, there is something I believe needs correction. Suppose I have a conditional format that extends from A2:A1000, to highlight in red if A2<A1, or A3<A2, etc. I want to check the conditional format in one selected cell, say A500. ... 9 Jul 2008 06:31

Time Format
Is there any way to custom time format to have milli-seconds also apart from HH:MM:SS tHANKS & rEGARDS -- Dr. Sachin Wagh MBBS, DHA, DPH ... 9 Jul 2008 06:31

adding stock items to accounting reports
In Accounting 2008 when you run sales or purchase reports, using the analysis tools option, results are returned in monetary format, in Excel 2007, if you want to view number of stock items you have to click on Options and Field List and then check the tick box Sales Units. We want to be able to set this as a ... 9 Jul 2008 05:29

Define alphabetic sequence to sort by
Hello, I would like to sort a column of words according to an alphabetic sequence that I define. For example, a sequence could be a, ā, i, ī, u, ū, ṛ, ṝ, e, ai, o, au, k, kh, g, gh, ṅ, c, ca, j, ja, ñ etc. The above sequence is part of the alphabet of a certain transliteration standard. Anyone know how to do ... 9 Jul 2008 16:48

Automatic closing Excel
All my opened excel documents are automatically closing when I close only one of them. Is it possible to change this? ... 9 Jul 2008 20:56

How do I convert a birth date to current age?
... 9 Jul 2008 03:27

Generic Worksheet Names
Hi all, I hope someone would be able to help me with my question. I have a workbook containing 5 worksheets: Main Sheet, July, June, May, April. In each of these worksheets I defined a couple of ranges using Insert>Name>Define. These ranges are Range1 and Range2. In the Main Sheet I have a formula that refers to ... 9 Jul 2008 17:50

averaging separate cells in excel excluding 0 values
Is it possible to average separate cells (i.e. H18,H22,H28,H30 and only those cells, not columns) And have it display the average of those in B30? mean while excluding all 0 values? ... 9 Jul 2008 05:29