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.
You can use SUMIF for this:
=SUMIF(F4:F13, "Yes", H4:H13)
Adjust the ranges if necessary.
HansVogelaar - THANK YOU ! :-), it worked - many thanks for speedy reply. Thanks once again