Hi
I have a pretty simple query, but I just cant get to work. I have a sheet that uses sumifs and countifs, it sums column J and looks at column I within certain ranges and also looks at column O, the issue is as soon as I add the criteria for column O it doesn't work, I have even tried a conversion formula in P and it doesn't work, just need some help please. Totals are in 29 & 30
Your answers are correct. Every row in P that has 3, has no value in J to sum (just text)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry, not sure what do you want to achieve with attached rough data... sumifs and counits can work but you must put criteria.... Please speak the criteria with expected result....
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
The data in O & P are offset by one row from column I so they will never match:
Try
=SUMIFS($J$2:$J$23,$I$2:$I$23,">=1",$I$2:$I$23,"<=30",$O$3:$O$24,"=OWNER OCC")
=SUMIFS($J$2:$J$23,$I$2:$I$23,">=1",$I$2:$I$23,"<=30",$P$3:$P$24,"=3")
As per my view, the problem is in column "F" Because you mentioned criteria as "Owner Occ", "Commercia", "Investmen", "Personal" in formula column "P" which based on criteria column "O"
Your column "O" depand on column "N"
and column "N" depand on column "F"
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks