criterialibreoffice-calc
how to use sumif to match multiple criteria on same range
how to use sumif to sum up multiple criteria on same range?
i use the formula =sumif(C3:C7,{"A","B","C"},D3:D7), it was able to sum-up only "A".
Even through =sum(sumif(C3:C7,{"A","B","C"},D3:D7)) does not work as well as shown in this screenshot 
Solution
Try
=SUMIF(C3:C7;"A";D3:D7)+SUMIF(C3:C7;"B";D3:D7) +SUMIF(C3:C7;"C";D3:D7)
or
=SUMPRODUCT(SUMIF(C3:C7;{"A";"B";"C"};D3:D7))
or
=SUMPRODUCT(D3:D7;(C3:C7="A")+(C3:C7="B")+(C3:C7="C"))
- Sort program not working, not sure why
- Fast & accurate atan/arctan approximation algorithm
- What's the difference between strtok_r and strtok_s in C?
- How memory address for pointer to arrays is same as an element in 2D array?
- Which is the best way to suppress "unused variable" warning
- How to use ellipsis in c's case statement?
- How can I exclude non-numeric keys? CS50 Caesar Pset2
- Fast ceiling of an integer division in C / C++
- Is there an invalid pthread_t id?
- How to Implement Universal Setter/Getter Functions for Interrupt-Driven Variables in Embedded C?
- How does SIMD (avx) processing work? for example, if I want 10 32 bit floats how do i fit in a 256 bit avx vector?
- FDCAN problems on STM32G4
- How does the call macro enable mutual recursion between functions f and g in this Hanoi Tower implementation?
- Running test on Rocket core CPU - global variable initialized to 0 is unsuccessful, output wrong value instead
- Interacting with C arrays without knowing the size
- Combination of two strings
- Avoiding strcpy overflow destination warning
- carriage return by fgets
- How to use special characters in C?
- Why does 1.0/100.0 == 0.1/10.0 give True?
- Is it correct to compare pointers in C?
- Force free() to return malloc memory back to OS
- How can I print to standard error in C with 'printf'?
- What is the standard behavior of fread in C on Windows?
- How is strtok removing lines it shouldn't have access to?
- Using array as smart point in C
- Assigning string to malloced 2d char array not working as intended
- How to refactor repetition inside a Makefile?
- Why does an empty preprocessor command still evaluate to something?
- How to implement variable sized array within C struct