|
|
|
January 5th, 2010 09:50 PM
by Max
|
3 |
146 |
|
|
|
|
1 |
153 |
|
|
Modify Formula by
carl
I use this formula:
=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)
I would like to change the formula so that it will use the value in cell A1
(eg 200) like...
|
|
2 |
150 |
|
|
|
|
1 |
190 |
|
|
Count cells by
Danni
Why is that my answer to my formula will not update? It was working fine at
first not it do not. I want to count text in each cell (eg. A5-A9). The
formula I...
|
|
1 |
145 |
|
|
|
|
1 |
120 |
|
|
help with sumproduct by
tleehh
using this formula
=SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+0,1),"yyyymm")))
when column E is mark with "X", i...
|
|
1 |
119 |
|
|
Tick mark by
Rohinikumar
Hi How do i add tick mark in excel sheet?i know its in symbol but i want to
prepare yes or no tick mark...
|
|
3 |
108 |
|
|
|
|
1 |
135 |
|
|
Create sublist in new worksheet by
Madeline Koch
I have one worksheet of all the people invited to an event. One column
indicates y for they're coming, n for they're not and blank if they have not
yet...
( 1 2)
|
|
10 |
164 |
|
|
Time Sheet Summary by
FMW
This is the 3rd time I am posting...is this visible?: Also, why can't I find
questions I posted?
-- I am having a problem with time sheet reporting. We...
|
|
1 |
126 |
|
|
sumproduct by
tleehh
using this formula
=SUMPRODUCT(H18:H103,--(TEXT(B18:B103,"yyyymm")=TEXT(DATE(YEAR(TODAY()),MONTH(TODAY())+0,1),"yyyymm")))
when column E is mark with "X", not...
|
|
3 |
90 |
|
|
|
|
0 |
110 |
|
|
|
|
1 |
112 |
|
|
|
|
6 |
115 |
|
|
Modify a Formula by
carl
Hi.
I use this formula:
=COUNTIF(I5:I40;TRUE)/COUNTA(I5:I40)
I would like to modify it so that the value I put in Cell A1 (eg 100) will
change the formula...
|
|
2 |
108 |
|
|
Lookup problem Excel capabilities by
Tarquin Krikery
Hi I have a bit of a problem I'm hoping someone can help with. Not sure if
what I want to do is possible within Excel so any help would be gratefully...
|
|
4 |
151 |
|
|
|
|
1 |
90 |
|
|
count unique values with auto-filter on by
Francisco Rodriguez[_2_]
Hello,
I'm trying to count unique numbers in a resulting list after filtering. I
have already learned how to count unique number in an unfiltered list...
|
|
3 |
105 |
|
|
Seperate info in a cell by
Petert[_3_]
Hi,
In cell A1 I have the following information:
Fri 30 Oct 09:11
What I would like to do, via a macro I imagine, is to delete the month
and to seprate out...
|
|
8 |
110 |