B
Bruce
Hi, I am trying to do a sumif in an array formula with 2 conditions.
In the second condition I am using the * wildcard to get cells that contain
the characters Buy.
The formula below entered as an array formula returns 0. I have confirmed
that the array formula is treating the * literally, as a character rather
than a wildcard.
Is there a way around this?
=SUM(IF((G$16:G$1000="Share Trade")*(H$16:H$1000="*Buy*"),I$16:I$1000))
Regards,
Bruce
In the second condition I am using the * wildcard to get cells that contain
the characters Buy.
The formula below entered as an array formula returns 0. I have confirmed
that the array formula is treating the * literally, as a character rather
than a wildcard.
Is there a way around this?
=SUM(IF((G$16:G$1000="Share Trade")*(H$16:H$1000="*Buy*"),I$16:I$1000))
Regards,
Bruce