Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 How to join two criterias in the SUMIF statement?, in Excel

views
     
TSk town shit
post Jan 28 2019, 02:57 PM, updated 6y ago

Enthusiast
*****
Junior Member
758 posts

Joined: Jan 2009
Hi Sifus,

How can I have multiple criterias in the sumifs statement?
Let's say I want to have two locations BCPF and EHQ. I tried to use + & ;
they just can't work

Attached Image
cnks
post Jan 28 2019, 02:59 PM

Getting Started
**
Junior Member
97 posts

Joined: May 2005


try add AND/OR into your SUMIF?
wych
post Jan 28 2019, 03:11 PM

Getting Started
**
Junior Member
63 posts

Joined: Jan 2019
sumif and sumifs are different.
are you using sumif or sumifs?
TSk town shit
post Jan 28 2019, 03:35 PM

Enthusiast
*****
Junior Member
758 posts

Joined: Jan 2009
QUOTE(wych @ Jan 28 2019, 02:11 PM)
sumif and sumifs are different.
are you using sumif or sumifs?
*
I just found out how to do it
can use parenthesis
=SUMPRODUCT(SUMIF(C2:C9, {"Mike","John","Pete"}, D2:D9))


 

Change to:
| Lo-Fi Version
0.0111sec    0.46    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 03:37 PM