Selective Sum Formula

  • Thread starter Thread starter jamesa
  • Start date Start date
J

jamesa

I need some assistance with what I thought was a simple
sum formula. Column "A" contains a month's name and
column "B" contains a value. How do I selectivly add in
a formula all the values in column "B" related to a
month. There may be 60-70 values related to January for
example. Thanks in advance for your assistance.
 
Hi jamesa,

Here's one way:

=SUMIF(A1:A100,"JANUARY",B1:B100)

Will sum all values in column B that correspond to January
in column A.

Biff
 
Back
Top