COUNTIF/SUMIF WITH REFERENEC

L

Lady Layla

Hi

We are trying to do something similar to CountIF or SUMIF but we need the
criteria to reference a cell rather than a set number. Is this possible and
how?


Thanks in advance!
 
L

Lady Layla

Thanks for replying Frank

This is not working for what we need -- we are trying to count how many are
larger than a certain number which may change.

In Cell A1 I currently have 8000
In Cell B1 I have =COUNTIF(C1:c15,">8000") What we need is to be able to have
a formula that says, count if the range is greater than A1

Thanks for your assistance




: Hi
: use
: =COUNTIF(A1:A100,B1)
:
: --
: Regards
: Frank Kabel
: Frankfurt, Germany
:
: : > Hi
: >
: > We are trying to do something similar to CountIF or SUMIF but we need
: the
: > criteria to reference a cell rather than a set number. Is this
: possible and
: > how?
: >
: >
: > Thanks in advance!
: >
: >
: >
:
 
L

Lady Layla

Thank you and Julie -- I had forgotten about the &!!

: Hi
: use:
: =COUNTIF(C1:c15,">" & A1)
:
: --
: Regards
: Frank Kabel
: Frankfurt, Germany
:
: : > Thanks for replying Frank
: >
: > This is not working for what we need -- we are trying to count how
: many are
: > larger than a certain number which may change.
: >
: > In Cell A1 I currently have 8000
: > In Cell B1 I have =COUNTIF(C1:c15,">8000") What we need is to be
: able to have
: > a formula that says, count if the range is greater than A1
: >
: > Thanks for your assistance
: >
: >
: >
: >
: > : > : Hi
: > : use
: > : =COUNTIF(A1:A100,B1)
: > :
: > : --
: > : Regards
: > : Frank Kabel
: > : Frankfurt, Germany
: > :
: > : : > : > Hi
: > : >
: > : > We are trying to do something similar to CountIF or SUMIF but we
: need
: > : the
: > : > criteria to reference a cell rather than a set number. Is this
: > : possible and
: > : > how?
: > : >
: > : >
: > : > Thanks in advance!
: > : >
: > : >
: > : >
: > :
: >
: >
:
 
Top