banner_ad

SUMIF FORMULA

Excel for Finance 1211 views 5 replies
User Avatar

Accountant
767 Points Posted on 08 July 2009
Hello friends, I need a formula of excel to fit in the attcached file. Actually I am to fit a sumif formula for 3 cretaria as the total of qty if it is of cat. “f” and belong to Delhi state and Grade “A”. I am not being able to understand how the formula should be put so that I can get the information immediate. Please help me
Attached File : 47 sheet.xls downloaded: 207 times
Reply Share Follow
On 08 July 2009 at 14:56 Report
Replies (5)
User Avatar

Landmark Group
23517 Points Posted on 08 July 2009

Your file (32_copy_of_47_sheet.xls) has been added been attached

Reply
On 08 July 2009 at 19:56
User Avatar

Accountant
767 Points Posted on 09 July 2009
Thanx a lot Mr. Prakash, ur formula is right. But when I tried it 21 put for other criteria, it didn’t work. Perhaps I am not being able 2 understand dis properly. Please make it clear 2 me as I was using dsum formula 4 which I am having 2 make a lots of criteria. My sheet is very long.
Reply
On 09 July 2009 at 10:05
User Avatar

Landmark Group
23517 Points Posted on 09 July 2009

In any ways it gonna work dear. Instead of this formula you can use one more formula in the attached file in case you have lots of data. :) cheers :)

Revert me back if this formula is also not working. I am sure that i will solve any problem in excel.

Reply
On 09 July 2009 at 10:44
User Avatar

Accountant
767 Points Posted on 09 July 2009
Thanx Mr. Prakash. The formula has worked. And I understood also. U r right that u r really a helping hand. KEEP HELPING AND SMILINGGGG…….
Reply
On 09 July 2009 at 13:14
User Avatar

Landmark Group
23517 Points Posted on 09 July 2009

You are welcome

Reply
On 09 July 2009 at 19:38


CCI Pro
Join CAclubindia WhatsApp Finance Community & stay updated with the latest TAX news, compliance alerts and important updates all in one place!

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Topic

More recent discussions | Post

Related Topics
Loading

Latest Job Openings

View all
Company
22 May 2026
Audit assistant

Displayandbeyond

Mumbai

CA

View Details
Company
16 May 2026
Audit clerk

mgirt & co

Bengaluru

CA Inter

View Details
Company
Featured 28 May 2026
SEMI QUALIFIED/ CA DROPOUTS/ ARTICLES

T R SOOD & CO

New Delhi

CA Inter

View Details
Company
ARTICLESHIP 23 May 2026
Article Assistants

Acupro Consulting

Gurgaon

CA Inter

View Details
Company
04 June 2026
Semi Qualified CA

Goyal Puneet & Associates

New Delhi

CA Final

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details
Company
22 May 2026
Sr. Financial Analyst - Consolidation

Search Synergy

Mumbai

CA

View Details
Company
Featured 27 May 2026
Lead Conversion Executive / Sales Closing Executive

SMJ global advisors pvt ltd

New Delhi

B.Com

View Details