Conditional Sum

  • Thread starter Thread starter D.Meconi
  • Start date Start date
D

D.Meconi

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?
 
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)
 
-----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?
.
Click to expand...

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)
 
Do you mean that the dates are month name strings? If so it would just be

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

HTH

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