help with moving formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

here is my formula:
=COUNTIF(OFFSET('Daily MP'!A:A,0,MATCH(H3,'Daily MP'!5:5,0)-1),"*04ac14*")-H10
when I drag my formula to the next column I only want certain values to
change. For instance in my reference of my offset I want the A:A to stay A:A
and not change to B:B. But in my match I want my lookup value to change from
H3 to I3. How would I solve this?
 
Hi
use
=COUNTIF(OFFSET('Daily MP'!$A:$A,0,MATCH(H3,'Daily
MP'!$5:$5,0)-1),"*04ac14*")-H10
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

making a portion of reference to a worksheet variable in a formula 1
make cell show blank when total is zero 18
Need help with Excel formula for a termination report 1
countif criteria 1
MAX value but with two comparison filtering criteria 5
Counting Cells with Multiple Range Criteria (Excel 2003) 7
Formula Problem in Macro 2
Trouble with offset formula 6

Back
Top