In cell G6, enter a formula using the SUMIF function to search range A4:A18 for records with a City value of Atlanta, then total the Participants Registered values listed in range D4:D18 for those records that meet the criteria. How to do this in excel
To achieve this in Excel, you can use the following formula:
=SUMIF($A$4:$A$18,"Atlanta",$D$4:$D$18)
This formula will search the range A4:A18 for records with a City value of Atlanta and then sum the corresponding numbers in range D4:D18.