Hello,
As you can see cell B4:B6 have type of statuses, I would like to count the number of those statuses that are in column "K" only if they fall between the particular the months indicated in C3:E3.
Hello,
As you can see cell B4:B6 have type of statuses, I would like to count the number of those statuses that are in column "K" only if they fall between the particular the months indicated in C3:E3.
Last edited by jgomez; 07-08-2016 at 03:57 PM.
Try this in C4 filled right/down
=COUNTIFS($K$3:$K$12,$B4,$J$3:$J$12,">="&C$3,$J$3:$J$12,"<="&EOMONTH(C$3,0))
Thank you, that did the trick.
How about updating your file to include the results you expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Use the Countifs statements as shown in the attached. Here is a tutorial to help you understand.
https://www.ablebits.com/office-addi...iple-criteria/
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks