Count if

Put your best Excel related tips and tricks here.
Forum rules
This is the place to put all of your Excel Tips & Tricks.
jbranco
Posts: 6
Joined: Fri Apr 19, 2013 2:59 am

Count if

Postby jbranco » Wed Jun 12, 2013 8:11 am

Hi Guys,

I'm having some trouble to find the answer for the following issue:
I have a table with two columns like this:

a 2
a 3
a 1
a 1


which formula can i use to determine how many rows i have where a = 1

Can anyone help?

Thanks

Jose

User avatar
hansfousert
Jet Reports MVP
Jet Reports MVP
Posts: 471
Joined: Thu Dec 13, 2007 8:25 am

Re: Count if

Postby hansfousert » Wed Jun 12, 2013 10:24 am

How about COUNTIFS? =COUNTIFS(YourCellsWithLetters;"a";YourCellsWithNumbers;"1")

Does this work for you?
Hans Fousert
Jet Reports Certified Trainer

jbranco
Posts: 6
Joined: Fri Apr 19, 2013 2:59 am

Re: Count if

Postby jbranco » Fri Jun 14, 2013 1:28 am

yes it does.
Thanks


Return to “Excel Tips & Tricks”

Who is online

Users browsing this forum: No registered users and 2 guests