View Single Post
  #1   Report Post  
Johannes B.
 
Posts: n/a
Default 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