| CARVIEW |
Select Language
HTTP/2 200
content-type: text/html; charset=utf-8
date: Fri, 15 Aug 2025 10:18:53 GMT
permissions-policy: interest-cohort=()
strict-transport-security: max-age=31536000; includeSubDomains
server: nginx
cache-control: s-maxage=48535, max-age=0
x-powered-by: Next.js
etag: "131miw1c2f1aa9p"
content-encoding: gzip
x-xss-protection: 1; mode=block
x-content-type-options: nosniff
referrer-policy: no-referrer-when-downgrade
content-security-policy: default-src 'self' http: https: ws: wss: data: blob: 'unsafe-eval' 'unsafe-inline'; frame-ancestors 'self';
vary: Accept-Encoding
x-cache: Miss from cloudfront
via: 1.1 cc1b2a0fc2bcb8c44f30e93e6d8cd00a.cloudfront.net (CloudFront)
x-amz-cf-pop: BOM78-P9
x-amz-cf-id: RbqmK0doGxsWDenu40o7EyHv2dwSfjXYx0pDpc6afk6FiTInCKmA2w==
Excel - Formulas - SUM with Criteria 
- Courses
- Tutorials
- Practice
- Jobs
Data Structure
Java
Python
HTML
Interview Preparation
Interview Preparation
- Interview Preparation For Software Developers
- Must Coding Questions - Company-wise
- Must Do Coding Questions - Topic-wise
- Company-wise Practice Problems
- Company Preparation
- Competitive Programming
- Software Design-Patterns
- Company-wise Interview Experience
- Experienced - Interview Experiences
- Internship - Interview Experiences
Excel - Formulas - SUM with Criteria
Last Updated :
Discuss
Comments
Which formula calculates the sum of values in column B where column A equals "East"?
=SUM(B:B,"East")
=SUMIF(A:A,"East",B:B)
=IF(A:A="East",SUM(B:B))
=COUNTIF(A:A,"East")
This question is part of this quiz :
Excel Basics QuizTags:
Share your thoughts in the comments
GeeksforGeeks
We use cookies to ensure you have the best browsing experience on our website. By using our site, you acknowledge that you have read and understood our Cookie Policy & Privacy Policy