Hello every one, first time user here. I am having trouble using COUNTIFS formulas to work out the below. I would like to find out the total number of incidents that occurred for each business within a reporting period. I can work out the totals however i cannot seem to get the formula to work within the reporting dates.
Cell B20: =COUNTIFS(B4:B17,B19,C4:C17,A20)
Example.jpg
Sorry for some reason i could not attach a workbook.
What you'll need is 2 more conditions for the dates. Both images are not the same (i.e. references may be different), but I'll stick to the first one.
Formula:
Please Login or Register to view this content.
Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Fantastic thank you very much quekbc
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks