subtotals
 

Hello,
I have a list of dollar amounts corresponding with days in the months. I am
trying to create a subtotal for each month and not each day of the month.
When I do subtotal I get a subtotal for each day of the month. How do I get
a total just for the month?

Thanks,
Chris

subtotals
 

try this for the month (if dates in col a) and data to sum in col b

=sumproduct((month(a2:a200)=3)*b2:b22)
to add another variable
=sumproduct((month(a2:a200)=3)*(b2:b22="joe")*c2:c 22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kanstrup" wrote in message
...
Hello,
I have a list of dollar amounts corresponding with days in the months. I
am
trying to create a subtotal for each month and not each day of the month.
When I do subtotal I get a subtotal for each day of the month. How do I
get
a total just for the month?

Thanks,
Chris

subtotals
 

BTW. You do NOT need to filter to use sumproduct.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
try this for the month (if dates in col a) and data to sum in col b

=sumproduct((month(a2:a200)=3)*b2:b22)
to add another variable
=sumproduct((month(a2:a200)=3)*(b2:b22="joe")*c2:c 22)

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"kanstrup" wrote in message
...
Hello,
I have a list of dollar amounts corresponding with days in the months. I
am
trying to create a subtotal for each month and not each day of the month.
When I do subtotal I get a subtotal for each day of the month. How do I
get
a total just for the month?

Thanks,
Chris

subtotals
 

Typo:
=sumproduct((month(a2:a200)=3)*b2:b22)

Think it was meant as:
=SUMPRODUCT((MONTH(A2:A200)=3)*B2:B200)

Ranges have to be identically sized
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

subtotals
 

Alternative.

Add a column to get the month (=MONTH(A2) for instance), and subtotal by
that column.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"kanstrup" wrote in message
...
Hello,
I have a list of dollar amounts corresponding with days in the months. I
am
trying to create a subtotal for each month and not each day of the month.
When I do subtotal I get a subtotal for each day of the month. How do I
get
a total just for the month?

Thanks,
Chris

subtotals
 

Thanks for the catch

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Max" wrote in message
...
Typo:
=sumproduct((month(a2:a200)=3)*b2:b22)

Think it was meant as:
=SUMPRODUCT((MONTH(A2:A200)=3)*B2:B200)

Ranges have to be identically sized
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---