Hlp w/Easy Formula

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
 
A

akphidelt

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to reference another cell in a worksheet 3
Need help with frequency formula 2
SumIF with 2 Conditions 6
Error when using Sum command 3
formula to count text entries and return text with most entries 8
Simple Formula displays "0" 1
Excel 2003 formula 2
Formula Problem. Anyone up for the challenge, lol? 5

Top