LinkBack URL
About LinkBacks
Good Morning,
Having trouble writing an If statement on this spread sheet. At the bottom left in red blocks I am trying to read hours based on Standard, Overtime and Doubletime indication in the next column and total for each hour rate.
Thanks !
Good Morning,
Having trouble writing an If statement on this spread sheet. At the bottom left in red blocks I am trying to read hours based on Standard, Overtime and Doubletime indication in the next column and total for each hour rate.
Thanks !
Try:
=SUMPRODUCT(--($F$7:$J$110=Q103),$G$7:$K$110)
copied down
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi bigduke6
You just needed a SumProduct formula instead of a sumif. See the attached with the answers at the bottom to the right of your red square.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks