Replies

I did mean Column D. Mucho thanks!!

Have a super weekend!!!

Marie

Thanks Bosco! That did the trick.

Thanks Hans! Have a fabulous weekend!!

Thanks Hans!

Thanks Han. I made a modification to my post as you were replying. What I am trying to do is average based upon multiple criteria but it seems to be counting everything.

{=AVERAGE(IF((WEEKDAY(‘CD042 Summary’!$A$2:$A$308)=2)*(‘CD042 Summary’!$E$2:$E$308=”Statements”)*(‘CD042 Summary’!$H$2:$H$308>0),’CD042 Summary’!$H$2:$H$308,0))}

This is counting all 308 rows. It does pull by the criteria specified but then divides by all of the rows within that range. How can I set it up to divide by only the cells that have data in them?

I am trying to create a countif array and it doesn’t appear to be looking at the criteria that I have added. It is counting every row. Can someone take a look at this and tell me where I went wrong. Thanks

=COUNT(IF((WEEKDAY(‘CD042 Summary’!$A$3:$A$10)=2)*(‘CD042 Summary’!$H$3:$H$10>0)*(‘CD042 Summary’!$E$3:$E$10=”Statements”),’CD042 Summary’!$H$3:$H$10,0))

What I really need is an Average IF but it still appears to not recognize the criteria that I have entered.

Thanks Hans!

Thanks John! Now that I have it set up correctly it works like a charm. Have a super day!

Thanks John

I have added your piece of code to my workbook, but cannot write a formula using this function. In the past, when functions were added to a database, I could use the function name to write my formula. Can you let me know what I am doing wrong.

Thanks

Thanks Hans!

Thanks Hans!

Hey Jerry!

Thanks for the speedy reply.

Thanks again!!!

Hans,

Is it possible to use this same type of formula to look for things in that column that do not have “can” in them?

Thanks again!

Thanks Hans! That worked like a charm!