Count someone give me an example of using a vlookup and counta function.
I have the following formula in cell Y2 of a sheet called "MedZone_Efficiency"
=SUMPRODUCT(($A$2:$A$2=A2)*($Z$2:$Z$2>0)*($F$2:$F$2))
Is there a way to reference the value in cell B3 of a tab named "Counts" and place it in the formula where I've highlighted below?
=SUMPRODUCT(($A$2:$A$2=A2)*($Z$2:$Z$2>0)*($F$2:$F$2))
I relize they are some dynamic rg formulas but because this spreadsheet is so many rows I'd rather just have a macro which can cut and paste the value in cell B3 of the tab named "Counts" into the formula in cell Y2 of a sheet named "MedZone_Efficiency". If it matters the file is named Draft_Rec.xls.
I have the following formula in cell Y2 of a sheet called "MedZone_Efficiency"
=SUMPRODUCT(($A$2:$A$2=A2)*($Z$2:$Z$2>0)*($F$2:$F$2))
Is there a way to reference the value in cell B3 of a tab named "Counts" and place it in the formula where I've highlighted below?
=SUMPRODUCT(($A$2:$A$2=A2)*($Z$2:$Z$2>0)*($F$2:$F$2))
I relize they are some dynamic rg formulas but because this spreadsheet is so many rows I'd rather just have a macro which can cut and paste the value in cell B3 of the tab named "Counts" into the formula in cell Y2 of a sheet named "MedZone_Efficiency". If it matters the file is named Draft_Rec.xls.
