Re: SUMIF Two Conditions
Wed, 8 Oct 2008 10:29:22 -0700 (PDT)
On Oct 5, 3:49 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> I didn't notice that portion. But glad you got it working.
>
> Just a note--did you really want to excel 12/31/2008 from the criteria?
>
>
>
> MJones wrote:
>
> > Hi Dave,
>
> > Let me apologize for posting this 3 times. Something str ...
|
i AM CREATING A DATA AND WANT TO SORT, BUT KEEP DATA TOGETHER
Wed, 8 Oct 2008 10:23:01 -0700
I am creating a data chart to keep records of old tenants, I am using cells A
thru j, left to right, but top to bottom needs to be left open to continually
add more tenants as they leave, this way I don't need to keep paperwork. I
would like to list these alphabetically, but do not want colum A to be
separa ...
|
sumif for multiple columns
Wed, 8 Oct 2008 10:00:01 -0700
Hi
I am using the following formula to try sumif on multiple columns, its not
working.
Help Please
=SUMIF('Sep Rev OR Raw'!A:A,'IP Revenue '!A:A,'Sep Rev OR Raw'!P:X)
Thanks
...
|
Vlookup one value then another
Wed, 8 Oct 2008 09:29:01 -0700
I have a spreadsheet (example below). I want to be able to look up the first
value which is a cost center, then within that cost center find an account
number and return the $value. For example I want to look up account 12001 in
Cost Center 300 and get the value answer $10.
How can I do this?
Column A ...
|
Need help with logic or Vlookup formula
Wed, 8 Oct 2008 09:13:09 -0700
I am relatively new to excel and need help with creating a formula.
Based on the table below my goal is to take information from column A (or a
range of cells), and return a min from column C and a max from column D.
For code 10060, I need the initials in column B to return when the min in
column C has bee ...
|
Excel cell to display summary of columns
Wed, 8 Oct 2008 08:59:23 -0700
I have a Excel sheet that has 71 rows and 140 columns. In the colums are
training courses the employees have taken and in the rows are my employees. I
want to be able to click on the cell that has an employees name and a window
to pop up with the summary of the courses they have taken.....like the
comment bo ...
|
running clock
Wed, 8 Oct 2008 08:59:22 -0700
I am using =now() function in cell A1 and frequently press F9 to update to
current time. Is there any way to continuously show the current time running
in the cell A1.
...
|
|
|
Help
Wed, 8 Oct 2008 08:55:05 -0700
Good morning all. I'm currently working on a attendance tracker, I have a
formula that will give us either half or full occurrence. Before we didnâ??t
need to track 0 but now we have. I tried to change the formula to give us a
full occurrence (1) but Iâ??m getting an error. Can anyone help me with thisâ?¦
Th ...
|
average in non-continuous set, excluding blanks
Wed, 8 Oct 2008 08:45:04 -0700
I want to calculate the average of non-adjacent cells (ie "=average(A3, D3,
G3, J3)"). In some cases there are blank cells in the set. How do I prevent
these blank cells from being counted as zeros? I do not want them included
in the average. I have only found instructions on how to do this when the
set ...
|
Split one worksheet to multiple
Wed, 8 Oct 2008 07:57:16 -0700
Can anyone help??? I have been tasked to write a macro that will take one
worksheet and split it up into multiple sheets. I have found wonderful
information if the cells split information was in the came column but my
issue comes in when I have multiple rowsâ?¦ i.e this is how I need it split by
what is xâ? ...
|
