<div>
That worked. Thank you!!!!!!!!!
</div>


<div>
<div class="content wysiwyg-content">
I have a count if statement that isn't working. On Sheet 1, column a, i have lots of different names. Many rows in column a are the same. In column b there is a value next to it. On sheet two, i put my count if statement. Say in sheet 2, column a, i have the name Ryan. In column b of sheet 2, i am trying to total all of those values on sheet 1, column b that have a value next to the name ryan, in column a. Does that make sense? So, i created a formula like this: =if(countif(sheet1!A:B,she<wbr />et2!A1),vl<wbr />ookup(shee<wbr />t2!A1,shee<wbr />t1!A:B,2,0<wbr />),0). This formula has worked in the past, but for some reason its not right now. On Sheet 2, how do i sum up all of the values next &nbsp;to Ryan on sheet 1? Thanks!!!!
</div>
</div>


I have a count if statement that isn't working. On Sheet 1, column a, i have lots of different names. Many rows in column a are the same. In column b there is a value next to it. On sheet two, i put my count if statement. Say in sheet 2, column a, i have the name Ryan. In column b of sheet 2, i am trying to total all of those values on sheet 1, column b that have a value next to the name ryan, in column a. Does that make sense? So, i created a formula like this: =if(countif(sheet1!A:B,sheet2!A1),vlookup(sheet2!A1,sheet1!A:B,2,0),0). This formula has worked in the past, but for some reason its not right now. On Sheet 2, how do i sum up all of the values next  to Ryan on sheet 1? Thanks!!!!

My countif statement isn't working.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.