Multiple count if formula?

O

Oakey

New Member
Joined
Jan 9, 2017
Messages
49
Office Version
  1. 365
Hi,
Im looking to create a daily sheet that can show me how many cases an operative opens / closes in a day from a master sheet of data.
Im looking for a countIf formula i think, but think it needs to count the number of 'Open' cases that appear with a specific date and username.

Screen shot of the date below

Case n. DateOrder n. ReasonDescriptionItemsNo UnitsLocationClosedResponse needed byWho create caseWho closed the caseResolutionAgree with CSDate closed
4604144206/01/202051911531550Worn itemmissing itembelt18fOpen21/01/2020Kasiayes
4596742706/01/202051943072588Worn itemmissing packageheadband1b2Open21/01/2020Kasiayes
4607247606/01/202051850157756Over 40 daysgood conditionall ok22eOpen21/01/2020Kasiayes
4603575106/01/202051929369412Worn itempulled threadsblouse124FOpen21/01/2020ChristinaYes
4605974206/01/202051937972262Missing Itemincomplete itembelt1D1Open21/01/2020ChristinaYes
4606498706/01/202051952639980Worn itemdirty trousers121FOpen21/01/2020ChristinaYes
4598684506/01/202051872647348Worn itemstrange smellstrousers113iOpen21/01/2020PaulinaYes
4588118106/01/202051952557360Wrong Itemdifferent sizeshoes119bOpen21/01/2020PaulinaYes
4598617606/01/202051952559086Worn itemsmellswomen clothes217eOpen21/01/2020PaulinaYes
4606635006/01/202051942207088Worn itemnot refundableunderwear120gOpen21/01/2020PaulinaYes
4607470706/01/202051882665172Over 40 daysgood conditioncoat118dOpen21/01/2020PaulinaYes
4610757407/01/202051911971748Worn itemno inner and external labeljeans117hOpen22/01/2020PaulinaYes
4610916307/01/202051952747488Worn itemnot refundableunderwear113gOpen22/01/2020PaulinaYes
4612292107/01/202051847304904Over 40 daysgood conditionjeans115fOpen22/01/2020PaulinaYes
4612427207/01/202051937125688Worn itemno inner and external labelknit top115gOpen22/01/2020PaulinaYes
4610334007/01/202051950382342Worn itemsweat smellsequin dress19gOpen22/01/2020weronikaYes

Can anyone help me with this formulas please?

Thanks is advance
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.
Sort by date Sort by votes
Try COUNTIFS:

Book1
QRST
1DateNameStatusCount
26/1/2020PaulinaOpen5
Sheet5
Cell Formulas
RangeFormula
T2T2=COUNTIFS(B:B,Q2,I:I,S2,K:K,R2)
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Question Question
VBA help to count Daytime,Nighttime and Summary
2 3
Replies
20
Views
890
Alex Blakenburg
A
D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
423
dshtesy
D
O
  • Solved
Travel Duration allowing for more than one day and different time zones
Replies
7
Views
151
myall_blues
myall_blues
staticfluids
  • Solved
Dynamic Array Formula (FILTER) But Show the Other Criteria with Blank
Replies
4
Views
518
staticfluids
staticfluids
R
  • Solved
Stumped on counting patients unique visits to a clinic
Replies
7
Views
539
Fluff
Fluff

Forum statistics

Threads
1,224,824
Messages
6,181,186
Members
453,020
Latest member
Mohamed Magdi Tawfiq Emam

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top