hello,
I’m trying to get the sum of a column, with specific criteria.
In cell 3B, in the "asbestos" sheet, I would like the sum of column H in the "incidents" sheet matching the criteria:
Incidents sheet:
Column A = asbestos
Column B = January
The code I’ve tried is:
I’m sure there’s really simple solution to this...
Please Login or Register to view this content.
Any help much appreciated!
many thanks
Rich
Rich, the values in A are not dates.
Also per your other (very similar) thread note my point in post # 7 re: C56 being a text value rather than a date.
Assuming you correct the above:
Though again as mentioned before if running XL07 you should use COUNTIFS (assuming no backwards compatibility concerns)Please Login or Register to view this content.
Last edited by DonkeyOte; 05-20-2009 at 11:06 AM.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Last time I was counting instances when a column had specific entry: i.e. how many accident codes in a given month. This time I need a formula that gives me the total of the contents of column h: the sum number of days lost in a given month.
I don’t need how many times a day is lost, I need how many days in total, in "asbestos" dept, in January.
I was hoping that might be just about different enough to merit a new thread?
apologies to all if not.
Rich
Adapting the post#2 formula re:H
I myself prefer the double unary approach which is marginally quicker:Please Login or Register to view this content.
See the link in my sig for more info on Sumproduct.Please Login or Register to view this content.
In XL07 you would use SUMIFS in this instance (significantly quicker):
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks