Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation
Hi
Could someone be kind enough to tell me what is wrong with the following formula =COUNTIF($F11:$AN11,$AR11:$BF11,AN11)=1 Thaks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation
You have specified too many arguments, what are you trying to achieve.
-- If this helps, please click "Yes" <<<<<<<<<<< "Gotroots" wrote: Hi Could someone be kind enough to tell me what is wrong with the following formula =COUNTIF($F11:$AN11,$AR11:$BF11,AN11)=1 Thaks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation
The syntax for COUNTIF is =COUNTIF(range, criteria)
So there are just two arguments while you have 3 Did you mean to use SUMIF? The syntax is =SUMIF(range, criteria, [sum_range]) where sum_range is optional So to sum the second range when the first range has the same value as AN11 you would need =SUMIF($F11:$AN11, AN11, $AR11:$BF11) However, the first range F:AN includes 35 cells while the second has only 15 so you will get an error message. Please tell us more about the problem best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Gotroots" wrote in message ... Hi Could someone be kind enough to tell me what is wrong with the following formula =COUNTIF($F11:$AN11,$AR11:$BF11,AN11)=1 Thaks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Data Validation
Just change the first Comma to Colon (:).
=COUNTIF($F11:$AN11:$AR11:$BF11,AN11)=1 But in your formula you are including the AR11 in your Countif Range and again mentioning the same cell as Criteria (AN11) =COUNTIF($F11:$AN11:$AR11:$BF11,AN11)=1 I think it should be like the below:- =COUNTIF($F11:$AM11:$AR11:$BF11,AN11)=1 Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "Gotroots" wrote: Hi Could someone be kind enough to tell me what is wrong with the following formula =COUNTIF($F11:$AN11,$AR11:$BF11,AN11)=1 Thaks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation, Custom | Excel Worksheet Functions | |||
Data Validation, Custom | Excel Worksheet Functions | |||
Data Validation, Custom | Excel Worksheet Functions | |||
Custom Data Validation | Excel Discussion (Misc queries) | |||
Custom data validation | Excel Discussion (Misc queries) |