View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
blackstar
 
Posts: n/a
Default sum of 1 column if info in another = specific text

nope, didn't work only gave me the sum of from ex h16:h18 regardless of info
in cells g16:g18

"Jonathan Cooper" wrote:

=SUMIF(G16:G18,"<spring",H16:H18)

"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