3 different types of purchases: ops, equip, rec
All on one spreadsheet. I want it to automatically add up the different dollar amount coinciding with the different types of purchases. People enter in their purchases all day long... and so everytime they put in their entry I want it to update the TOTAL amount spent on ops, equip, rec etc.
Range being column where we write ops, equip, rec
Criteria being "the word" I am having it look up
Sum Range being the column with the dollars