Hlp w/Easy Formula
 

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

Hlp w/Easy Formula
 

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

Laura Cook

"Dax Arroway" wrote in message
...
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

Hlp w/Easy Formula
 

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.

"Dax Arroway" wrote:

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