I'd like to do 2 things, and I think the date is causing me issues, because I user the same formula where the crtitera is not a date and it works. For each date, I wasn to Count the W, L, and I also want to Sum the Col Q. Would go in Columns T and U and the sum money would go in Column X
In T2 dragged down & acrossFormula:
Please Login or Register to view this content.
This is perfect.. but have 2 more questions.. wonder if I wanted to add in 1 more criteria where only count if Column N is greater than 6? And how can do the same thing in Column X except insetad of counting, I want to Sum the money from Q?
To add col N useand for col X you just use sumifs & add the column to be summed.Formula:Please Login or Register to view this content.
Ok.. the count is works perfect now! But I am getting an error on the Sumifs.. it keep pointing the #>6.. not sure what's asking for..
What formula did you use?
I used the one above but changed to Sumifs instead of Countifs then added in Coumn Q instead of T
Can you post the formula you tried.
SUMIFS has an additional range:
=SUMIFS(sum_range,criteria_range_1,crieria_1,criteria_range_2,crieria_2, ...)
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
=sumifs($p:$p, $a:$a,$w2,$n:$n,">6")
There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.
Thanks for that, it should be Q:Q at the start not P:P
Perfect.. it all works! Thanks a ton!!! I'll mark as solved!
Glad to help & thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks