Prev: Macro to import multiple sheets
Next: I'm Paste values stupid
From: Leon on 11 Feb 2010 18:42
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
From: Paul on 12 Feb 2010 08:10
=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
--
If the post is helpful, please consider donating something to an animal
charity on my behalf ..... and click Yes


"Leon" wrote:

> 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
 | 
Pages: 1
Prev: Macro to import multiple sheets
Next: I'm Paste values stupid