Calculations Based on Day of the Week

[bals2oo8]

I've created a calendar and I need for it to auto calculate occurrences based on the value placed in the cell. I have this working as I'd like, but I'm having issues with specific days of the week, Monday and Friday. These 2 days are considered high volume days and I need it to multiply the occurrence by 2, no matter which value is used while also only counting any other day's values by 1, or by not multiplying them.

Example:
I call in to work on Tuesday so a "C" is placed in that cell. It should calculate this value, "C", as 1 point. But if I call in on Monday, it should calculate it as "C*2"
Using =countif(A5:G23,"C") currently to calculate when C is used and this adds to the to total occurrences. Which works, but doesn't take into consideration if the "C" falls onto a Monday or Friday.

I hope I'm being clear.

 

[Carpaccio]

I'm guessing that Mondays are in Row A and Fridays in Row E, so if you could Count the entire range first, then count Monday and Friday a second time then could you use:
=COUNTIF(A5:G23,"C") + COUNTIF(A5:A23,"C") + COUNTIF(E5:E23,"C")

Hope that works
Regards
Alan

 

[bals2oo8]

Yes. That's what I figured out to do. Thanks for the response.

 

[snjpverma]

You can use this formula

=SUM(COUNTIF(INDIRECT({"A5:A23","A5:G23","E5:E23"}),"c"))