| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sumifs help
I have the following formula.
=SUMIFS(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) It now needs to be changed to a formula that can handle text instead of numbers. How do i do it? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumifs help
Use Countif instead of Sumif from =SUMIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) to =CountIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) Do you really have a function Countifs with an "S" at the end? thie maybe an UDF that needs to be modified. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171628 Microsoft Office Help |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumifs help
SUMIFS/COUNTIFS are Excel 2007 functions!
Bob "joel" wrote in message ... Use Countif instead of Sumif from =SUMIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) to =CountIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) Do you really have a function Countifs with an "S" at the end? thie maybe an UDF that needs to be modified. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171628 Microsoft Office Help |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumifs help
Tried countif comes up with "too few arguments"
I looked at the syntax of countifs and there doesnt appear to be an equivalent "sumrange", which in the formula is Table1[2]. Some additional info that you may require, Table1[2] contains either a X or is blank and there will only ever be 1 cell in the range Table1[2] that is a match. Any more ideas? Regards Primed Hi "Bob Phillips" wrote: SUMIFS/COUNTIFS are Excel 2007 functions! Bob "joel" wrote in message ... Use Countif instead of Sumif from =SUMIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) to =CountIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) Do you really have a function Countifs with an "S" at the end? thie maybe an UDF that needs to be modified. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171628 Microsoft Office Help . |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumifs help
COUNTIFS doesn't require a sumrange.
HTH Bob "primed" wrote in message ... Tried countif comes up with "too few arguments" I looked at the syntax of countifs and there doesnt appear to be an equivalent "sumrange", which in the formula is Table1[2]. Some additional info that you may require, Table1[2] contains either a X or is blank and there will only ever be 1 cell in the range Table1[2] that is a match. Any more ideas? Regards Primed Hi "Bob Phillips" wrote: SUMIFS/COUNTIFS are Excel 2007 functions! Bob "joel" wrote in message ... Use Countif instead of Sumif from =SUMIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) to =CountIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) Do you really have a function Countifs with an "S" at the end? thie maybe an UDF that needs to be modified. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171628 Microsoft Office Help . |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
sumifs help
Correct, which makes the countif solution not workable. ie i have to search
two colums for two criteria matches then copy the result from the matching row in column (Table1[2]). Table1[2] used to contain a number 1 it now contains an X or is blank. Any more suggestions? Your help much appreciated. Regards Primed "Bob Phillips" wrote: COUNTIFS doesn't require a sumrange. HTH Bob "primed" wrote in message ... Tried countif comes up with "too few arguments" I looked at the syntax of countifs and there doesnt appear to be an equivalent "sumrange", which in the formula is Table1[2]. Some additional info that you may require, Table1[2] contains either a X or is blank and there will only ever be 1 cell in the range Table1[2] that is a match. Any more ideas? Regards Primed Hi "Bob Phillips" wrote: SUMIFS/COUNTIFS are Excel 2007 functions! Bob "joel" wrote in message ... Use Countif instead of Sumif from =SUMIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) to =CountIF(Table1[2],$A$11:$A$22,$A38,$B$11:$B$22,$B38) Do you really have a function Countifs with an "S" at the end? thie maybe an UDF that needs to be modified. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=171628 Microsoft Office Help . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I use sumifs - | Excel Worksheet Functions | |||
| Sumifs (I think) | Excel Worksheet Functions | |||
| SUMIFS | Excel Worksheet Functions | |||
| SUMIFS and OR | Excel Discussion (Misc queries) | |||
| SUMIFS | Excel Discussion (Misc queries) | |||
Hybrid Mode
