Thread
:
Can I use more complex logical expression for sumif as creteria?
View Single Post
#
8
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey
Posts: n/a
Can I use more complex logical expression for sumif as creteri
Oops, didn't see the identical solution in the other subthread...
In article ,
JE McGimpsey wrote:
This is a bit shorter:
=SUMPRODUCT(--((A3:A10="MA")+(B3:B105000)0),F3:F10)
Reply With Quote
Can I use more complex logical expression for sumif as creteri