Need help on a countif function will count the number of inspections in a particular area.
For example if taking the first line, it counts the number of inspections for 1st Jan for planting but want it where it also counts for if the site type falls in Wells aswell.
For Grass Maintenance row:Formula:
Please Login or Register to view this content.
Please do not upload Macro Enabled Workbooks where the VBA Project is protected and locked for viewing. no-one should enable macros if they can't see the code.
And, if you are going to set Calculation to Manual on your workbook, it's worth making people aware of that too.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Does this only count for those that fall in the site type wells?
It counts whatever is in cell I1. You could put a drop down Data Validation selection in there, or anywhere else for that matter. For testing, I just put "Wells" into cell I1 (no quotes).
Are you able to send me a copy of the worksheet with that formula in it?
Apologies, that should have been:Formula:Please Login or Register to view this content.
Although I made the field that I added absolute, I forgot to do the same with the other fields.
Regards, TMS
can you send me a copy of the spreadsheet working as it will not work?
See attached
If I wanted to put in the criteria the name 'Wells' to pick up from the inspection sheet, how would I do that?
=COUNTIFS(Inspections[[Grass Maintenance]:[Grass Maintenance]],">3",Inspections[[Sample Date]:[Sample Date]],">=" & B6,Inspections[[Sample Date]:[Sample Date]],"<" & C6,Inspections[[Site Type]:[Site Type]],$C$2:$C$1347 “Wells”)
Tried this but does not work
working now thank you
You're welcome.
And for anyone else watching:Formula:Please Login or Register to view this content.
Regards, TMS
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks