calculating by month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jake - 30 Mar 2008 17:18 GMT

Hello,

I was trying to use sumproduct to calculate if column a was a date and
column b was item and column c was a dollar amount so I would know how many
items sold during a specific month and year. It works to calculate the exact
date (7/2/2007 or 7/4/06) but I want it to calculate by month (i.e. all july
07) so I will know how many items sold in a given month and year. Many
thanks.

Signature

Jake
--
Jake

Reply to this Message

Bob Phillips - 30 Mar 2008 17:40 GMT

=SUMPRODUCT(--(YEAR(A2:A200)=2007),--(MONTH(A2:A200)=7),--(B2:B200="item"))

for the count, and

=SUMPRODUCT(--(YEAR(A2:A200)=2007),--(MONTH(A2:A200)=7),--(B2:B200="item"),C2:C200)

for the amount

Signature

---
HTH

Bob

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

> Hello,
>
[quoted text clipped - 7 lines]
> 07) so I will know how many items sold in a given month and year. Many
> thanks.

Reply to this Message