Formula Problem

  • Thread starter Thread starter discgolfer_1999
  • Start date Start date
D

discgolfer_1999

I am new to excel and have ready through several of the topics and tip
and cannot find a solution to work for the formula I am trying t
create.

What i wants is =IF one cell is greater than another cell, and
third cell equals a certain number, than count "1"

I have tried the COUNTIF and IF statements and just cant get it t
work. Any help and guidance would be greatly apprecaited

Thanks

Scot
 
Maybe...

=if(and(a1>a2,a3=12345),1,0)



discgolfer_1999 said:
I am new to excel and have ready through several of the topics and tips
and cannot find a solution to work for the formula I am trying to
create.

What i wants is =IF one cell is greater than another cell, and a
third cell equals a certain number, than count "1"

I have tried the COUNTIF and IF statements and just cant get it to
work. Any help and guidance would be greatly apprecaited

Thanks

Scott
 
Thanks, that worked pretty good, The part I dont get to work is
designating the third cell for multiple cells


This is the formula I have =IF(AND(A1<F1,D1=3),1,0)

But If I change it to =IF(AND(A1<F1,D1:D10=3),1,0)

I get an error message. Is there something I am missing here?

Thanks again

Scott
 
What do you mean by D1:D10=3?

All 10 cells have to be equal to 3
or
one or more have to be equal to 3.

=if(and(a1<f1,countif(d1:d10,3)=10),1,0)
or
=if(and(a1<f1,countif(d1:d10,3)>0),1,0)
 
I am needing the IF A1 is greater than F1, and If a single Cell withi
D1:D10 has the number 3 in it, then to count the total within tha
range.

If Cells D1, D3, D7 and D10 all have the number 3 in it, then it woul
give me a count of 4, since there would be 4 cells with the number
within that range.

=IF(AND(A1<F1,D1=3),1,0)

THis formula worked perfect but only reads D1 and no other cells, an
if I change it to read D1:D10 so it this formula reads mutiple lines,
get an error message

I am not sure If this helps or I am making it clear.

Thanks

Scot
 
Man that is awsome. That worked perfect, but i did not notice befor
but one more thing I need to get to work with this formula is to se
the F1 portion range.

Again this is what I have that works

=IF(A1<F1,COUNTIF(D1:D10,3),0)

But I now also need if A1(Date) is greater than F1:F10 Range (Date) an
then the rest of the COUNTIF statement works perfect.


Ultimatly what this formula is asking is that if the absolute date i
greater than the dates in the F1:F10 Range and the D1:D10 range has
Number 3 in the cell than count the individual number of cells tha
meat this rule.

I am sure learning a lot though and appreciate your help

Hopefully getting a fix here will get me going

Thanks again and any further help here would be great.

Thanks

Scot
 
Hi Scott

This shoul do the trick:

=IF(A1>MAX(F1:F10),COUNTIF(D1:D10,3),0)

HTH

Wouter
 
Back
Top