Forum Discussion
Solved
formula for selecting value if matches criteria.
I have a spreadsheet where the value in column F is the criteria (Yes) in order to include value in column H to create a total cost at end. Is there a formula to do this. Again I'm not all that excel...
You can use SUMIF for this:
=SUMIF(F4:F13, "Yes", H4:H13)
Adjust the ranges if necessary.
- Thank you Peter, it didn't quite work but I can see the potential of using this in another sheet. Thanks once again
