LinkBack URL
About LinkBacks
SIR
I AM USING COUNT IF AND SUMIF BUT NOT EXECUTING WELL
MY COUMN H HAS AMOUNT
SO I AM USING THOSE LIKE
COUNTIF(h:H,AND(">25000","<100000") FOR AMOUNT 25000 AND ABOVE BUT LESS THAN 1 LAC
SIMILARLY SUMIF
BUT NOT EXECUTING AS DESIRED
KINDLY GUIDE
SIR
I AM USING COUNT IF AND SUMIF BUT NOT EXECUTING WELL
MY COUMN H HAS AMOUNT
SO I AM USING THOSE LIKE
COUNTIF(h:H,AND(">25000","<100000") FOR AMOUNT 25000 AND ABOVE BUT LESS THAN 1 LAC
SIMILARLY SUMIF
BUT NOT EXECUTING AS DESIRED
KINDLY GUIDE
try using sumproduct
Regards
Sean
Please add to my reputation if you think i helped (click on the star below the post)
Mark threads as "Solved" if you have your answer (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [code]
Please supply a workbook containing example Data: It makes its easier to answer your problem & saves time!
You'd need COUNTIFS and SUMIFS, which aren't in Excel 2003 (only Excel 2007 and onwards).
For Excel 2003 try:
=SUMPRODUCT(--(H1:H1000>25000),--(H1:H1000<100000))
That will do a COUNTIF, a SUMIF would be:
=SUMPRODUCT(H1:H1000,--(H1:H1000>25000),--(H1:H1000<100000))
Adjust the range as required (don't use the whole column H:H, or it will be SLOW)
See how to use these fumctions here.
http://www.techonthenet.com/excel/formulas/countif.php
http://www.techonthenet.com/excel/formulas/sumif.php
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Thank you...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks