|
|
|
|
11 |
195 |
|
|
Excel Circular Reference SUM HELP! by
SpecOpBookie
Hi all, I'm fairly new with Excel so let's see if I can get a quick answer
for my question :).
I am trying to add a base number to whatever number i Input...
( 1 2)
|
June 8th, 2009 01:28 PM
by Luke M
|
11 |
175 |
|
|
display lbs and ozs by
Trail Dog[_2_]
i use the formula # "lbs" ??/16 "ozs" for calculating my backpacking gear.
how do i change it to show 3 lbs 2 ozs instead of 3 lbs 2/16 ozs ? thanks
( 1 2)
|
|
11 |
197 |
|
|
Blank cell not really blank by
OperationsNETTC15
I am using Excel 2007 and returning data into a table using xfODBC, which
returns a number of blank cells. If I do an ISBLANK on the blank cells, it
returns...
( 1 2)
|
|
11 |
241 |
|
|
|
June 15th, 2009 05:35 PM
by Roman
|
11 |
288 |
|
|
Negative Numbers by
PL
How do I change all the numbers in a row into positive ones without doing so
individually?
Thanks
( 1 2)
|
|
11 |
251 |
|
|
BIG question by
Wu
I would like to write a marco that:
Let me input data in a cell, and when I , the cursor will move to
right cell to let me input data again..................
( 1 2)
|
|
11 |
256 |
|
|
sumproduct assistance pleas by
Ajay
Afternoon all
I have a table of raw data containing an inventory list by department, I
need to count the number of items in each dept which are out of date....
( 1 2)
|
|
11 |
237 |
|
|
|
June 23rd, 2009 12:49 PM
by DaveC
|
11 |
542 |
|
|
Help with formula by
Lynda
I was hoping someone might be able to help me with a better formula or a code
that will give me a result based on the formula below as it comes back saying
I...
( 1 2)
|
|
11 |
274 |
|
|
|
June 9th, 2009 05:15 PM
by Kiley
|
11 |
219 |
|
|
Counting using multiple criteria by
Rodman
I am using Excel 2003 and I would like to count the number of cells within a
range thar meet multiple criteria. (Note this function is availiable in 2007
as...
( 1 2)
|
|
11 |
147 |
|
|
Format cell to show '-' by
Gary
Looking for a way to make entries into cell show negative (-) indicator by
default. For instance if '1' is entered, it will display '-1'.
Excel 2003
( 1 2)
|
May 11th, 2009 05:19 PM
by Gary
|
11 |
214 |
|
|
What causes = not to work? by
Amy
On several occasions lately I've had the misfortune of my spreadsheet
refusing to treat a formula as a formula. Instead it shows me the formula.
i.e....
( 1 2)
|
May 15th, 2009 05:33 PM
by Amy
|
11 |
299 |
|
|
Error problem by
Ayo
I have this formular:
=SUMPRODUCT(--(Tables!$C$2:$C$2979=$A4),--(Tables!$D$2:$D$2979=$B4),--(Tables!$E$2:$E$2979="Yes"))
but it is showing as an error. Iknow...
( 1 2)
|
May 20th, 2009 04:52 PM
by Ayo
|
11 |
366 |
|
|
using if for multiple criteria by
enna49
Hi
I have used the formula below for adding across cells if certain criteria.
This does work, however is there a cleaner way of doing this. Example Data...
( 1 2)
|
|
11 |
172 |
|
|
|
|
11 |
241 |
|
|
|
|
11 |
248 |
|
|
Substitute Text for Plus or Minus by
DOUG
Is there a way to substitute the words "UP" or "ROSE" and "DOWN" or "FELL"
for a calcualted value referenced in another cell in a concatenated statement...
( 1 2)
|
June 12th, 2009 07:06 PM
by DOUG
|
11 |
242 |
|
|
|
June 26th, 2009 08:15 PM
by TG
|
11 |
185 |