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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
TrickDave 
Register To Reply
Bookmarks