I would like to do a conditional sumif using two criteria. I am able to do this using CSE's or using the Conditional Sum Wizard, the problem I encounter though is that I need to use a wildcard.
Example
This is using the Condtional Sum Wizard
=SUM(IF($A$20:$A$50=E56,IF($C$20:$C$50=F56,$G$20:$G$50,0),0))
but what I would like is something like this
=SUM(IF($A$20:$A$50="Test",IF($C$20:$C$50="Car*",$G$20:$G$50,0),0))
The wildcard is so that all variations are acounted for.
Does anyone know how to do this
Example
This is using the Condtional Sum Wizard
=SUM(IF($A$20:$A$50=E56,IF($C$20:$C$50=F56,$G$20:$G$50,0),0))
but what I would like is something like this
=SUM(IF($A$20:$A$50="Test",IF($C$20:$C$50="Car*",$G$20:$G$50,0),0))
The wildcard is so that all variations are acounted for.
Does anyone know how to do this