How can I use or funcition inside sumifs functiıon ?
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
|