Dave Peterson wrote:
Actually, I overlooked the complete thread save that last question.
Thanks for answering the real question.
Ragdyer wrote:
Dave might have overlooked the first part of the question.
Try this:
=SUMPRODUCT(--(A1:A4A5*0.9),A1:A4)
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may
benefit !
---------------------------------------------------------------------------
"Dave Peterson" wrote in message
...
J.E. McGimpsey explains it all at:
http://www.mcgimpsey.com/excel/doubleneg.html
HokieLawrence wrote:
Biff,
You're my hero. That works like a charm.
Now that I've got them counted, is there also a way to SUM
those values
if
they meet that same condition?
Also, can you explain how that works? I've never seen the (--(
operation
and I'm not sure what it's making Excel do.
Thanks,
HokieLawrence
"Biff" wrote:
Hi!
As near as I can tell,
COUNTIF(A1:A4,A1:A40.9*A5)
translates to:
=SUMPRODUCT(--(A1:A4A5*0.9))
Biff
-----Original Message-----
I have a large array of data approximately 41 columns
wide by about 180 rows
deep. The columns are headed by date information
(weekly) and the rows are
resources.
I would like to count values in each row based on
conditions of the columns.
Specifically, I'd like to count the number of resources
in each week was
above a number that changes based on different criteria
for each week.
Ultimately I manually entered in a different COUNTIF
function for each week,
but is there a way that I can count based on some kind of
function, for
example something along these lines: COUNTIF
(A1:A4,A1:A40.9*A5)
Hope anyone knows what the heck I'm talking about and
might be able to help
me out of this jam.
Thanks,
HokieLawrence
.
--
Dave Peterson
--
Dave Peterson
Hi There
It sounds as if this is related to a question I have.
The area on my spreadsheet that I will enter whole numbers is from V9
to HB172.
A value will be entered in many columns along any given row.
For each one of these values entered, I would like to multiply that
value with a value entered in row 1 for each of the columns. The
solution will be entered in column A and added with all other solutions
in that row.
example:
a10=10 a15=15 a25=25
v1=(1*10)+(7*25) v10=1 v15=0 v25=7
q1=(2*10)+(6*15) q10=2 q15=6 q25=0
r1=(3*10) r10=3 r15=0 r25=0
s1=(5*15) s10=0 s15=5 s25=0
Any suggestions what formula and formatting to put in column 1.
Thanks in advance, Lob