Copy and paste value into sumproduct formula

dsebrin

New Member
Joined
Jul 26, 2010
Messages
8
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.
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,298
Messages
5,510,469
Members
408,791
Latest member
bwirth

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top