Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
Does anyone know how to create a sumif formula with an expression in the
critria. Below is the formula I am trying to use. Thanks! =SUMIF($J:$L,$J1"6000000",$L:$L) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
=SUMIF($J:$J,""&6000000,$L:$L)
or =SUMIF($J:$J,""&$a$1,$L:$L) (I did change the ranges, though.) Owen888 wrote: Does anyone know how to create a sumif formula with an expression in the critria. Below is the formula I am trying to use. Thanks! =SUMIF($J:$L,$J1"6000000",$L:$L) -- Dave Peterson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
My best guess:
=SUMIF($J:$J,"6000000",$L:$L) Biff "Owen888" <u27266@uwe wrote in message news:66fa10fb6bb9e@uwe... Does anyone know how to create a sumif formula with an expression in the critria. Below is the formula I am trying to use. Thanks! =SUMIF($J:$L,$J1"6000000",$L:$L) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
=SUMIF($J:$J,"6000000",$L:$L)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Owen888" <u27266@uwe wrote in message news:66fa10fb6bb9e@uwe... Does anyone know how to create a sumif formula with an expression in the critria. Below is the formula I am trying to use. Thanks! =SUMIF($J:$L,$J1"6000000",$L:$L) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF Question
The only critera you are looking at there is if J1 is greater than 6,000,000.
To find all numbers over 6000000 in that range use: =SUMIF($J:$L,"6000000",$L:$L) The plain english would be "For all values in columns J and L over six million, add the value in the same row column L to the total" "Owen888" wrote: Does anyone know how to create a sumif formula with an expression in the critria. Below is the formula I am trying to use. Thanks! =SUMIF($J:$L,$J1"6000000",$L:$L) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumif of Sumif perhaps? | Excel Discussion (Misc queries) | |||
SUMIF | Excel Worksheet Functions | |||
SUMIF Question Criteria | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
sumif Question | Excel Discussion (Misc queries) |