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: 219 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 Topics :
- Consultation
- E-way notices for FY 22-23
- Gst file not created
- Regarding 3CEB query
- Omitted E-Commerce Sales Reported in Table 14 but
- Omitted sales shown in GSTR-1 Table 14 but not in
- EWAY BILL TAKE OUT OF OTHER COMPAMY
- Penalty & late fee for late ITR filing
- Business discontinued as Government took possessio
- Which Aviation Services Can Air Ticketing Professi
Related Topics :
CAclubindia
