Formula Problem

  • Thread starter discgolfer_1999
  • 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
 
D

Dave Peterson

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
Click to expand...
 
D

discgolfer_1999

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
 
D

Dave Peterson

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)
 
D

discgolfer_1999

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
 
D

discgolfer_1999

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
 
W

wouter.magre

Hi Scott

This shoul do the trick:

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

HTH

Wouter
 
Top