| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Easy formula | Excel Discussion (Misc queries) | |||
| Easy formula | Excel Discussion (Misc queries) | |||
| Should be easy - Value and Formula | Excel Discussion (Misc queries) | |||
| If Then formula - Should be easy!?! | Excel Discussion (Misc queries) | |||
| Easy formula, but need help please | Excel Worksheet Functions | |||
Hybrid Mode
