Forum Discussion
Formula to add up across sheets and to identify data in two different columns
Help needed with excel formula. I have an excel document with 4 sheets. I want sheet1 to add up data from sheet3. I want it to add up all the items in column D with matching serial numbers eg 12345...
Hi James,
Could you please provide small sample file to be concrete with possible solutions.
Eg. I want to add all serial numbers that match in column D (eg 199660) that are also shown as Open in column I but to display the result on the sheet named totals
James, thank you.
So, in sheet Totals only serial numbers from sheet CRIS with status Open and nothing more?
I want to add up all the ones that are shown as “open” in column I for all the ones with matching serial numbers in column D.
so column D will have a 6 digit number in the box and I want to know how many with the matching 6 digit number are shown as a status of “open” in column I, but with the result showing in a box on the sheet that is named “totals”
