I have a worksheet in which a want to take the data from three columns and put the total number of that data into a new sheet. I am using Excel 2010 and there are 517 rows of data within the 3 columns.
For example:
Each row in column 1 contains either claim or policy
Each row in column 2 contains either home or motor
Each row in column 3 contains either internal or external

So I want the total number of "Motor" "Claim" and "Internal" from the three columns for a seperate sheet.

What formula can be used for this?

I tried this formula to get the data from two columns but it keeps coming up as 0: Sumproduct(--(Sheet!I2:I124="Claim")--(Sheet1!J2:J124="Motor"))

Thanks!