Excel Quaries
This query is : Resolved
31 December 2009
Dear Sir
I use following formulas
SUMIF(range, criteria, sum_range)
in which one range and one criteria
But I have two range and two criteria
range criteria sum_range
A : A “>350” C : C
B : B “=Ram” C : C
How can calculate the above quarries.
u can mail
dharmco@gmail.com
Thanks
I use following formulas
SUMIF(range, criteria, sum_range)
in which one range and one criteria
But I have two range and two criteria
range criteria sum_range
A : A “>350” C : C
B : B “=Ram” C : C
How can calculate the above quarries.
u can mail
dharmco@gmail.com
Thanks
13 March 2012
Use the sumifs formula. You can enter multiple ranges and multiple criteria.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Clarification Required on Filing Form 141 for Joint Buyers
- HOUSING LOAN ISSUE
- Taxability of Partnership firm for FY 2025-26
- Portuguese Civil Code IT Return
- TODAY INCOME TAX SITE IS NOT WORKING ANY OFFICIAL EXTENSION
- Can we choose not to report losses in ITR3 if they cannot be carried forward?
- GST Rate for Catering Services
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
- EXPORT PAYMENT
- NRI ITR2 account in 2025-26.
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
