Countif worksheet function or anything else that will fix my problem

  • Thread starter Thread starter dawgy
  • Start date Start date
D

dawgy

I need help. I am working on a spreadsheet where I am trying to coun
information from 2 seperate columns (A & B). In Column A, I have eac
month of the year. In column B I have other information about specifi
loans I am working on (i.e. approved withdrawn, denied, etc...... I a
trying to write a formula which will calculate the number of Januar
apporovals in the spreadsheet. How do I do this
 
Use SUMPRODUCT:

=SUMPRODUCT(($A$1:$A$500="January")*($B$1:$B$500="Approved"))

I just chose 500 as the bottom row. However, adjust to suit your
purposes. Also, with SUMPRODUCT you can not reference the entire column
(i.e. A:A).
 
Back
Top