Reference a cell value in a formula

L

Leon

I have the following formula:

=SUMPRODUCT((MONTH(Summary!$F$7:$F$15000)=1)*1)

I want the "15000" to be replaced by the varaible value of a cell in an
other worksheet ("Summary").

I tried using INDIRECT but it didn't work.

Thanks in advance
 
P

Paul

=SUMPRODUCT((MONTH(OFFSET(Summary!$E$7,0,0,C4,1))=1)*1)

C4 in this case is the cell that holds the number of items to be used in the
calculation
 

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

Adding a condition to VBA CountIF 7
Problem getting Excel formula to Calculate 2
Array Formula In IF Function 0
Urgent 4
Macro will copy formula instead of value 6
Excel VBA 1
INDIRECT informulas 1
Copy adjacent Sheet and name from a list 42

Top