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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I use OR function inside SUMIFS 3
SUMIF, use List as a Range 2
SUMIFS error 1
Truncate 3
sumproduct or sumif? 3
SUMIF & OR 6
How to avoid '*' being used as wildcard in SUMIF? 6
Sumifs 9

Back
Top