Using Vlookup with sumif on different sheets of the same workbook

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.

Attach a sample workbook.

Make sure there is just enough data to demonstrate your need.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

I have added fictitious data to the +5Summary sheet in F2 and F3.

F2 should look up all 2000 in Attendance sheet, column E (E3 and E6 in this example) and count the number of times it occurs (2) and sum "O" if it is >+.09 (.10 + .10 = .20)

Thanks!

in F3

=COUNTIF(Attendance!E:E,2000)

in F4

=SUMIFS(Attendance!O:O,Attendance!E:E,2000,Attendance!O:O,">0.09")

John,

Thank you, the F4 formula worked perfectly.

I think perhaps I wasn't clear enough in my initial thread, as in the sumif, I only want to count the occurrences of 2000 "E" where the the data in "O" is >=.09 In this instance it would only be 1 occurrence where that happens.

Thanks again!

Use COUNTIFS and add the second criteria as per SUMIFS