Hlp w/Easy Formula

  • Thread starter Thread starter Dax Arroway
  • Start date Start date
D

Dax Arroway

How do I write a formula that Sums all the numbers in column F for only the
rows that also have a number of 37 in column I?

In other words, Add all the numbers in column F together who also have a 37
in column I, if not, then don't count them.

It seems like a simple thing but I'm not smart enought to figure it out.
Thanks for your help in advance!
-- Dax
 
Write this formula in a cell

=SUMIF(I:I,37,F:F)

If you have specific ranges then use your ranges like I2:I300 or whatever it
is.
 
Back
Top