Ok, heres what i need to do...
Similar too...
=SUMPRODUCT(--('Sheet1'!$K$2:$K$3223>=B5),--('Sheet1'!$K$2:$K$3223<B6))
but, i want to
Should I be using some kind of SUM(IF statement ?
Regards,
Lee
Similar too...
=SUMPRODUCT(--('Sheet1'!$K$2:$K$3223>=B5),--('Sheet1'!$K$2:$K$3223<B6))
but, i want to
- SUM(Sheet2!E2:E3223)
- ('Sheet1'!$K$2:$K$3223>=B5),--('Sheet1'!$K$2:$K$3223<B6)
Should I be using some kind of SUM(IF statement ?
Regards,
Lee