=SUMPRODUCT(--(B2:B7="F"),--(LEFT(C2:C7,12)="Notification"),A2:A7)

"Bob" wrote:

I am trying to use dual ranges to add data. I want to sum the notification
devices that are funded. In this example, Column C has three Notification
devices, Column B says two of them are funded and I want to add the $650 &
$650 together automatically.

Cost Funding Status Work
$650.0 F Notification devices not loud enough
$650.0 F Notification devices not loud enough
$600.0 U Notification devices not loud enough
$863.0 U Install fire suppression system
$600.0 F Install fire suppression system
$235.0 U Install fire detection system

The formula should look something like If C2:C7="Notification*" and
B2:B7="F" then sum A2:A7

thanks