I have two formulas and I am wanting to hopefully combine them.
I have a weekly schedule that I create. And I need it to count how many hours are used for an event but only for that event. For example
I want it to take the left product (to get the number of hours) of only cells that have the word SHOW in it and add all those up.
If I just do left product to get the number it takes all them.
Anyways here is my left product formula
=IF(D9="","",--LEFT(D9,1))+IF(E9="","",--LEFT(E9,1))+IF(F9="","",--LEFT(F9,1))
My other is a crude way of doing it. But then I have to tell it to look for exact numbers and word to search for I just want it to search for the word
=COUNTIF(A9:F9,"4 Show")*4+COUNTIF(A9:F9,"6 Show")*6+COUNTIF(A9:F9,"8 Show")*8
Is there anyway to just say
=IF(A9:F9="*Show",--LEFT(A9:F9,1))
I want it to add all the numbers up for Show in one box, and then add up all the numbers for Admin, then so forth.
Picture is included to hopefully make it easier.
Schedule test.jpg
Bookmarks