IF .......

[basavarajkh]

Hi

I used some formula like below for my Report's


Completed Count of Comp!

=D34+D74 =COUNTA(Comp!A:A)-1


Pending Count of Pending!

=G34+G74 =COUNTA(Pending!A:A)-1


Creation Count of Creation!

=I34+I74 =COUNTA(Created!A:A)-1


Results

=IF(Q11=R11,"Y ","N ")&IF(Q14=R14,"Y ","N ")&IF(Q17=R17,"Y ","N ")


I want single formula for all above

 

[basavarajkh]

Pls find the Download Link


http://speedy.sh/xXsgF/TGT-Vs-ACH..xls


Thanks in Advance


Regards

Basavaraj K H

 

[inbp]

Hi Basavaraj


Can you share you file

 

[basavarajkh]

Pls find the Download Link


http://speedy.sh/xXsgF/TGT-Vs-ACH..xls

 

[inbp]

Hi Basavaraj!


Please find the formula below


=IF(Q14=COUNTA(Comp!A:A)-1,"Y","N")&IF(Q11=COUNTA('Pending 1'!A:A)-1,"Y","N")&IF(Q11=COUNTA(Created!A:A)-1,"Y","N")


feel free to ask if find any issue


Regards,

Muhammad Shakeel

 

[basavarajkh]

Thank U so much


I edited your formula

like below

=IF(Q11=COUNTA(Comp!A:A)-1,"Y ","N ")&IF(Q14=COUNTA('Pending 1'!A:A)-1,"Y ","N ")&IF(Q17=COUNTA(Created!A:A)-1,"Y ","N ")


is'it ok, but I want direct reference, I mean instead of cell

Q11, D34+D74.

Q14, G34+G74.

Q17, I34+I74.


I wait for response, Pls

 

[inbp]

Hi


=IF((D34+D74)=COUNTA(Comp!A:A)-1,"Y ","N ")&IF((G34+G74)=COUNTA('Pending 1'!A:A)-1,"Y ","N ")&IF((I34+I74)=COUNTA(Created!A:A)-1,"Y ","N ")


I hope its work now.


Thanks & Regards,

Muhammad Shakeel