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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
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

R
  • Solved
Stumped on counting patients unique visits to a clinic
Replies
7
Views
369
Fluff
Fluff
skyh3ck
  • Question
1st match column header, 2nd lookup a value in same column, 3rd return corresponding value from the very first column ?? need help
Replies
2
Views
292
skyh3ck
skyh3ck
M
  • Solved
Returning results based on multiple criteria
Replies
5
Views
291
DanteAmor
DanteAmor
I
  • Question
Formula to match criteria
2
Replies
18
Views
528
ItalianPlatinum
I
J
  • Solved
Difference between dates based on follow on work
Replies
5
Views
417
Alex Blakenburg
A

Forum statistics

Threads
1,215,350
Messages
6,124,439
Members
449,160
Latest member
nikijon

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