Can I use more complex logical expression for sumif as creteria?

Hi!

Try this (using Marks example):

=SUMPRODUCT(--((A3:A10="MA")+(B3:B10>5000)>0),F3:F10)

Biff

"xwenx" <xwenx@discussions.microsoft.com> wrote in message
news:80FC0DBA-045A-4CB3-BD39-AADEB3939C4D@microsoft.com...
> Thank you, Mark.
> What if the condition is an "or" (not and). Either the first or the second
> condition is met, then do the sum up...
>
> "Mark Lincoln" wrote:
>
>> You can use SUMPRODUCT like this:
>>
>> =SUMPRODUCT(--(A3:A10="MA"),--(B3:B10>5000),F3:F10)
>>
>> Your state abbreviations are in A3:A10, your numbers to test on are in
>> B3:B10, and the numbers to sum are in F3:F10 (column 6). Change to
>> suit your circumstance.
>>
>>

Good solution, Biff. Nice and neat!

I was trying something similar but got a #VALUE error. Then my
solutions suggested themselves to me and in the interests of time (I do
this during slack moments at work) I dropped my original effort.

Three solutions to one problem. That's why I like this newsgroup. :-)