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 that match across the rows 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:I518="Claim")--(Sheet1!J2:J518="Motor"))
Thanks!
Bookmarks