Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with Formula
Hi all,
I am getting so confused with this formula that my head is aching can anyone help? =IF((AB16="",0,AND(COUNTIF($AB$16:$AB$30,AB16)=1,B 16='lot', C16='Y')),COUNTIF($AB$16:$AB$30,AB16),1/COUNTIF($AB$16:$AB$30,AB16))) I am guessing that i dont have the syntax correct or the brackets in the correct place, please let me know if you need further explanation although im just as confused. Thanks Tanya |