Thread
:
SUMPRODUCT
View Single Post
#
4
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
SUMPRODUCT
=SUMPRODUCT(-(Month(A1:Z1)=1,A2:Z2)
or
=SUMPRODUCT((Month(A1:Z1)=1)*A2:Z2)
--
Don Guillett
SalesAid Software
"Ellen G" wrote in message
...
Okay -- sorry. I typed the formula in my original message incorrectly.
Here
is the type of formula I've actually been using that is not working:
=SUMPRODUCT(Month(A1:Z1)=1,A2:Z2)
What am I doing wrong???
Ellen
"Ellen G" wrote:
I have a spreadsheet that looks something like:
Row A 1/1/07 1/2/07 1/3/07 .... 12/31/07
Row B 4 2 5 .... 9
I would like to sum everthing in row B within a certain month. I have
tried:
=SUMPRODUCT(Month(A1:A365)=1,B1:B365)
This is not working. Would someone tell me what I'm missing?
Thanks so much.
Ellen
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett