This is first day I have become member.
Greetings to all of you.

Can someone tell how I can use or function inside SUMIFS function in excel.

Best wishes,

Baybora

Greetings!

For an OR logical, you could just add two functions together. For instance,
to add evertyhing in column B where column A equals "John" or "Smith"

=SUMIF(A:A,"John",B:B)+SUMIF(A:A,"Smith",B:B)

This returns same results as the psuedo-formula:
=sumif(A:A,"John" or "Smith",B:B) 'Not a real formula!
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Baybora" wrote:

This is first day I have become member.
Greetings to all of you.

Can someone tell how I can use or function inside SUMIFS function in excel.

Best wishes,

Baybora