Conditional Sum
 

I do not have the"wizzard" so...I am trying to write a
formula to SUMIF: One collumn meets a certain critera,I
sum another collumn...no problem, however, I need another
condition, only if a third collumn is a specific date. How
can I write it to look at a collumn (range) for a specific
MONTH?
Any ideas?

Conditional Sum
 

Try SUMPRODUCT

=SUMPRODUCT((A1:A100="condition1")*(MONTH(B1:B100) =10),(C1:C100))

will sum just October plus your other condition

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"D.Meconi" wrote in message
...
I do not have the"wizzard" so...I am trying to write a
formula to SUMIF: One collumn meets a certain critera,I
sum another collumn...no problem, however, I need another
condition, only if a third collumn is a specific date. How
can I write it to look at a collumn (range) for a specific
MONTH?
Any ideas?

Conditional Sum
 

-----Original Message-----
I do not have the"wizzard" so...I am trying to write a
formula to SUMIF: One collumn meets a certain critera,I
sum another collumn...no problem, however, I need another
condition, only if a third collumn is a specific date.
How
can I write it to look at a collumn (range) for a
specific
MONTH?
Any ideas?
.


In situations such as this, I often create a 3rd
calculated column to combine the criteria I want to seach -
for example lets say you need to match both column B
(I'll say it has the "Part ID" in it) and column C
(perhaps the date sold). In column D I create a formula
such as D1=B1 & Format(C1,"mmddyyyy")
Now I do my SUMIF by looking at column D, so if I want to
sum column A for all Part IDs "CD-123" sold on 1/5/04 I
would use this formula:

= SUMIF(D:D,"CD-123010520034",A:A)

Conditional Sum
 

What it does not seem to want to take is a "range" of
months.??
-----Original Message-----
Try SUMPRODUCT

=SUMPRODUCT((A1:A100="condition1")*(MONTH(B1:B100 )=10),
(C1:C100))

will sum just October plus your other condition

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"D.Meconi" wrote in
message
...
I do not have the"wizzard" so...I am trying to write a
formula to SUMIF: One collumn meets a certain critera,I
sum another collumn...no problem, however, I need
another
condition, only if a third collumn is a specific date.
How
can I write it to look at a collumn (range) for a
specific
MONTH?
Any ideas?


.

Conditional Sum
 

Do you mean that the dates are month name strings? If so it would just be

=SUMPRODUCT((A1:A100="condition1")*(B1:B100="Octob er")=10),(C1:C100))
--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
What it does not seem to want to take is a "range" of
months.??
-----Original Message-----
Try SUMPRODUCT

=SUMPRODUCT((A1:A100="condition1")*(MONTH(B1:B100 )=10),
(C1:C100))

will sum just October plus your other condition

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"D.Meconi" wrote in
message
...
I do not have the"wizzard" so...I am trying to write a
formula to SUMIF: One collumn meets a certain critera,I
sum another collumn...no problem, however, I need
another
condition, only if a third collumn is a specific date.
How
can I write it to look at a collumn (range) for a
specific
MONTH?
Any ideas?


.