Search results

Thank you so much for the help. I need to do the same groups and numbers monthly throughout the rest of the fiscal year and then reproduce it for FY22. I do like the example so maybe I can set it up for monthly use. Thanks for helping with the formulas. I looked at quite a few explanations but...

Hi. Thank you the reply. The third part is the sum of attendees for Recorded and Pre-School 0-5. I need the number events for each type and age group along with attendance for them. This is for monthlyLibrary State and National statistics. Thanks

I'm having a problem finding the count and the sum of one criteria with two conditions. I have a category of Self-Directed Virtual with different age groups for it and then a column for the total attendance for each age group. The main file has two columns with drop down lists for types and...

Chihiro, Thank you. That is what it needed to work. I didn't think of it because when I switched worksheets and click on the FY2015 cell the absolute reference was returned but those cells aren't relative anyway. Thanks. David

Hi, My apologies for asking as this topic has probably been covered a few times but I looked through the threads to locate the same or similar question but did not find one. I have six locations that turn in monthly numbers for 70 entries that need to be totaled on to a master sheet each month...

I cant figure out why I'm getting two different number when I use the formula =SUM(H3/72*J36) when there is a cell reference to J36, I getting 3723. If I put the a straight forward formula in as =SUM(12*318) the result is 3816 which is correct. I hope this helps to make it easier to know what...

Thank you for the messages. My apologies. Narayan as you point out is what I'm trying to do. In my workbook the sheet that handles the calendar and the total number of service hours per month is a second sheet titled Stats Days that will work out to give you the number 318 for January and 288...

I'm creating a worksheet for a service desk which stats are taken once a month and then extrapolated for the rest of the month. I've created a calendar that will count the number of days that the service desk is open for the different hours of the week, see worksheet file. I'm having a problem...

Hi, Thanks for all of the help. My apologies for not responding sooner. Yes in column B is text formatted to ddd. Your suggestion to use =SUMPRODUCT(--(WEEKDAY(B53:B76)=2)*(C53:C76)) worked out well. The first time I tried your examples I had some errors which it seemed there may have been...

Thanks for the response. I see what you mean about the display format. Sorry about not indicating the row numbers in the second section but I see you saw what I was trying to do. When using both of your examples they're not returning the number and total in the corresponding cell. I'm trying not...

I'm creating a sheet to count customers on a daily basis for each month and the whole year. I also would like to sum the monthly total for each day of the week. I also would like the sheet to format itself for the next year. The sheet is setup my day of the month and I started the month using 1-...