Please see attached workbook. In Sheet 1 (Drivers), there are a list of incidents and costs of said incidents. This information shows in Sheet 2 (Summary) as a simple count of incidents and costs per driver.
In column L on Drivers tab, there is a Yes/No dropdown box. I need to make sure that only data that is marked 'Yes' goes through to the summary sheet. Currently I have it set that the sheet will count everything.
hi there. why is C3 showing 50? shouldn't it be 100? "Driver" worksheet in row 3 and 15 shows Abi Smith, Windscreen Incident Type, and Paid as Yes. if it's 100, then in B3:
=COUNTIFS(Driver!$C:$C,$B$1,Driver!$B:$B,$A3,Driver!$L:$L,"Yes")
C3:
=SUMIFS(Driver!$G:$G,Driver!$C:$C,$B$1,Driver!$B:$B,$A3,Driver!$L:$L,"Yes")
for the different Incident type, change the red portion accordingly
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi,
Yes you are quite right, C3 should have been 100 - it was a typo.
Thank you for your answer, this works perfectly for the first incident type. Could you let me know what the $B$1 refers to, so I know how to change it for the other incident types please.
$B$1 is just the cell that contains the category
if you change it to B$1 in both formulas, they should copy to the right
Thank you very much - that has just all clicked into place in my head now.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks