Summing Data with matching Dates

  • Thread starter Thread starter tasar
  • Start date Start date
T

tasar

I have a spread sheet set up like this example:

A B C
Apl 21 R1000 10
Apl 21 R1001 15
Apl 22 R1002 13


I would like to sum column "C" when column "A" equals April 21. This
seems like a simple task, but I've seem to have hit a wall. Please
e-mail, I have a feeling I'll miss out on the response. Thanks

(e-mail address removed)
 
Dave,

Are the 'dates' just a text form. If so, then

=SUMIF(A1:A10,"Apr21",C1:C10)


--

HTH

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