Countifs formula for >18 -

[basavarajkh]

Hi


Please find Link below


http://speedy.sh/TcMrR/Greater-than-18-Hrs-Less-than-24-Hrs.xlsx


help me to write Countifs formula for >18 - < 24 Hrs in cell B4 > Sheet "UPC Pend".


Thanks in Advance


Regards

Basavaraj K H

 

[Debraj]

Hi Basavaraj!

=COUNTIFS('Red Alert UPC'!AB:AB,">0.75",'Red Alert UPC'!AB:AB,"<1",'Red Alert UPC'!AE:AE,'UPC Pend'!$A4,'Red Alert UPC'!AG:AG,"<>"&"#N/A")

Regards,

Deb

 

[NARAYANK991]

Hi Bhasoriya ,


The problem is the "<" sign in the text <24hrs.


Use the following construct :


=COUNTIFS('Red Alert UPC'!$AE$2:$AE$29,$A4,'Red Alert UPC'!$AG$2:$AG$29,"<>#N/A",'Red Alert UPC'!$AH$2:$AH$29,"="&B$3)


Now , the contents of B3 will be taken as text.


Check out your file here :


http://speedy.sh/4EnNf/Greater-than-18-Hrs-Less-than-24-Hrs.xlsx


Narayan