If anyone can help, I have created a very basic sumif formula and it is just returning the corresponding row's value, in this case 15. I am actually trying to use this between two sheets and it is doing the same thing where it is not searching based on the criteria, but rather only giving the value from the corresponding row. Any help is appreciated. The formula in Cell F1 is =sumif(A1:A3,A1,D1:D5). Capture.PNG
Bookmarks