Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Checking on two values
To count the numbers of rows that include the number "16" in column "I", I
use the following formula: ANTALL.HVIS(I:I;"16") (I think this is called COUNT.IF in english) I want to count the numbers of rows that include both this and the letter "A" in column "B". (Meaning not counting rows which just fulfill one of these requirements.) How do I write this formula? (Please feel free to write the english formula, I will find out how to write it in norwegian.) Regards Johannes |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
How do I summarize totals for a list of values in Excel? | Excel Worksheet Functions | |||
Checking ALL values in a range | Excel Discussion (Misc queries) | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Formula to list unique values | Excel Worksheet Functions |