I need a formula to Calculate Number of People Starting with the Letter J in Month starting with J in cell M19. I know you use a countifs formula for the name and then the month of 1, 6, 7. I attached the file.
I need a formula to Calculate Number of People Starting with the Letter J in Month starting with J in cell M19. I know you use a countifs formula for the name and then the month of 1, 6, 7. I attached the file.
Does this work for you?
Try this:
=SUM(COUNTIFS($C$6:$C$80,{1,6,7},$A$6:$A$80,"=J*"))
Alan
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks