SUMIF Formula

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

Why wouldn't this formula work? The value of A6 is Oct. What I am trying to
do is summarize on my 'Summary' page some transactions by month. The dates
for these transactions on my 'Details' page are currently formatted as
Oct-01-03.


=SUMIF(Details!A1:A170,LEFT(TEXT(Details!A1,"MMM"),3)=A6,Details!E1:E170)

T.I.A.
Dayton
 
Ed,

You can't have a test in the value part of a SUMIF. Does this do what you
want

=IF(LEFT(TEXT(Details!A1,"MMM"),3)=A6,SUMIF(Details!A1:A170,LEFT(TEXT(Detail
s!A1,"MMM"),3),Details!E1:E170),"")



TH

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