i want the sum column B if column A equals spring. if it says anything other
than spring i don't want column B to take into account the values of B

"Domenic" wrote:

Just to be clear, do you want to sum Column B if the corresponding
values in Column A equals 'Spring' or if Column A doesn't equal
'Spring'.?

In article ,
blackstar wrote:

no dice, gives me a result of 0 every time. #'s are in column B "spring" is
in column A formula is in column B

"Domenic" wrote:

Try...

=SUMIF(A1:A100,"<Spring",B1:B100)

Hope this helps!

In article ,
blackstar wrote:

How could i get the sum of a column that would not include in the total
sum
any cells in another column that has certain info
ex: if any corresponding cells in column A="spring" then do not include
in
total sum of cells in clumn b