| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Less then simple question
i'm struggling.
I need to find all the totals in a spreed sheet that are less then 10.00. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Less then simple question
KG,
Try the =SUMIF() formula. That should get you what you need. "KG" wrote: i'm struggling. I need to find all the totals in a spreed sheet that are less then 10.00. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Less then simple question
=SUMIF(A1:A100,"<10")
Gord Dibben MS Excel MVP On Tue, 1 Jul 2008 10:00:01 -0700, KG <KG @discussions.microsoft.com wrote: i'm struggling. I need to find all the totals in a spreed sheet that are less then 10.00. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Less then simple question
Or if you are just trying to count the number of totals less than 10:
=COUNTIF(A1:A100,"<10") "KG" wrote: i'm struggling. I need to find all the totals in a spreed sheet that are less then 10.00. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Very Simple Question | Charts and Charting in Excel | |||
| a very simple question | Excel Discussion (Misc queries) | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Simple Question? | Excel Discussion (Misc queries) | |||
![KG[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
