One last thing, can I get this to go down a column until it meets a blank
cell rather than specify a range?
"Frank Kabel" wrote:
Hi
:-)
thought so after seeing the formula the OP tried
Sorry for my typos
--
Regards
Frank Kabel
Frankfurt, Germany
Myrna Larson wrote:
Hi, Frank:
Maybe the problems is with missing parentheses:
=SUMPRODUCT(--(MONTH(A1:A100)=10),--(YEAR(A1:A100)=2004),B1:B100)
On Fri, 29 Oct 2004 18:16:05 +0200, "Frank Kabel"
wrote:
Hi
try
=SUMPRODUCT(--(MONTH(A1:A100=10),--(YEAR(A1:A100=2004),B1:B100)
|