Re: A question about the Count/CountIf function
- From: "Roger Govier" <roger@xxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 12 Jan 2007 08:55:00 -0000
Hi Carl
Try
=SUMPRODUCT(($A$1:$A$100="ABC")*($B$1:$B$100<1)*($C$1:$C$100>200))
Change ranges to suit, but ensure that they are of equal length.
--
Regards
Roger Govier
"carl" <carl@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:81B41734-BA5D-4D1C-A591-F30E4854CB7F@xxxxxxxxxxxxxxxx
I have a counting question.
I have some columns that have codes and numbers in them and want to
count
the amount of times that they appear in that specific column. That is
easy.
But I also have other data in other columns that I want the count
function to
refer to. So I have one column with codes in (e.g. ABC and DEF) and I
have
another column with weights in (e.g 0.7 and 1.4). I want to create a
function that counts how many times ABC appears when it weighs less
than 1.0.
Can I do this?
Also, can I expand the function further. For example I have another
column
with length in it (e.g 120 and 340). Can I have a function that
counts the
amount of times that ABC appears when it weighs less than 1.0 and is
longer
that 200?
.
- Prev by Date: Re: add up negative numbers
- Next by Date: Re: How to automatically goto to today's date
- Previous by thread: Re: Counting certian rows to sum them
- Next by thread: Re: How to automatically goto to today's date
- Index(es):
Relevant Pages
|
