I need a formula to achieve a calculation based on a couple of things
Looking for a formula to look through column A and count the quantity of cells that contain the #12 "=COUNTIF(A1:A9)" in this case the answer is 6. I then need, if a cell in A did contain a 12 create a SUM based on the corresponding cell C. And then multiply the amount of Cells in A that contain 12 with the SUM of the corresponding Cells in C. In this case it would be 6x24. 6 being the amount of 12's, and 24 being the SUM of the #'s that exist in column C in a row that contained a 12. I hope a clarified that correctly. Please ask questions if need be. Thank you VERY much
Mcottuli is putting the column and row header just to show where the cells are. So the reference is one row and one column off. Also, if using A1 as the cell reference, it may cause error if a1 is not 12.
Thank you very much, however I asked the question incorrectly. Was I need is just the SUM of column C where column A = 12. In other words, there is no need to multiply A and B. I just need to Identify anything in column C that has an A record of 12 and SUM up the C column. Apologize for the confusion.
=COUNTIF(B:B,B1)*SUMIF(B:B