How can I use or funcition inside sumifs functiıon ?

  • Thread starter Thread starter Baybora
  • Start date Start date
B

Baybora

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!
 
Back
Top