I would like to apologize for stating that my "-SUM()" function worked for me!

It did, apparently, but it was for a particular set of data. The result gave the correct answer, but the procedure was wrong, and only appears to work when the data is presented in a certain way.

Barry Houdini gave the right formula to use, =SUMPRODUCT(), using the same number of rows in each part.

Olimpiainfante said that Barry's formula worked,

I used SUMPRODUCT with the formula you gave me and for some reason.....IT WORKED!!!!

Here's the reason. Analyzing Barry's formula:

=SUMPRODUCT((I2:I1300="Jan")*(K2:K1300="Revised"))

It says that if "Jan" is contained in a given row of the range I2:I1300, to make (I2:I1300="Jan") equal to "TRUE". And, if the same row in K2:K1300 contains "Revised", then make (K2:K1300-"Revised") also equal to "TRUE". Now, the product (*) makes each TRUE become the number 1, which makes the product of the two quantities 1. Now, the function SUMPRODUCT has first done the product, obtaining a 1, then it does a SUM, obtaining the number of times both "Jan" and Revised" occurred on the same row.

Barry, have I explained this right?