Jul 12 2022 03:05 AM
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 savvy and hope you experts in the community can help me out, my apologies if it's such an easy one.
Thanks in advance, Claire
Jul 12 2022 03:14 AM
SolutionYou can use SUMIF for this:
=SUMIF(F4:F13, "Yes", H4:H13)
Adjust the ranges if necessary.
Jul 12 2022 03:21 AM
Jul 12 2022 03:57 AM
@Hans Vogelaar - THANK YOU ! :-), it worked - many thanks for speedy reply. Thanks once again
Jul 12 2022 03:58 AM
Jul 12 2022 03:14 AM
SolutionYou can use SUMIF for this:
=SUMIF(F4:F13, "Yes", H4:H13)
Adjust the ranges if necessary.