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
How to join two criterias in the SUMIF statement?, in Excel
How to join two criterias in the SUMIF statement?, in Excel
|
Jan 28 2019, 02:57 PM, updated 6y ago
Show posts by this member only | Post
#1
|
Junior Member
758 posts Joined: Jan 2009 |
|
|
|
|
Jan 28 2019, 02:59 PM
Show posts by this member only | Post
#2
|
Junior Member
97 posts Joined: May 2005 |
try add AND/OR into your SUMIF?
|
|
Jan 28 2019, 03:11 PM
Show posts by this member only | Post
#3
|
Junior Member
63 posts Joined: Jan 2019 |
sumif and sumifs are different.
are you using sumif or sumifs? |
|
Jan 28 2019, 03:35 PM
Show posts by this member only | Post
#4
|
Junior Member
758 posts Joined: Jan 2009 |
|
Change to: | 0.0111sec
0.46
6 queries
GZIP Disabled
Time is now: 29th March 2024 - 03:37 PM |