Hello,
I am trying to use either Vlookup with sumif, OR match & Index with sumif in a spreadsheet with multiple sheets, but not having any luck.
I am in a cell titled "SUN" cell F3(sheet +5 Summary) and trying to lookup all data from B3 (2000) on sheet "Attendance" where 2000 (and several other data points) are in column "E" and when "2000" is found in column "E" check column "O" and add all matches of "2000" from E to all data >= .09 in column "O".
So if 2000 appears 20 times in "E" (Attendance sheet), it will have 20 corresponding data points in column "O", but I only want to sum those data points from "O" if they are >=.09.
Additionally, my preference right now is to NOT use VBA if it's possible without it.
Bookmarks