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: 171 times
Menu
SUMIF FORMULA
Replies (5)
Your file (32_copy_of_47_sheet.xls) has been added been attached
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.
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.
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…….
You are welcome
Recent Threads
- Excess Payment on RCM
- AOC4 auto population of previous year data
- Exports against INR PO payable by Domestic Company
- Which websites are best for government exam prepar
- TDS on maturity payment of LIC of india
- ITR2 Gold ETF short and long term
- Query under faceless assessment
- Purchase of business
- Refund of ITC for advance paid to overseas supplie
- Clubbing query (when gifts given to multiple fami
Related Threads
CAclubindia
