LinkBack URL
About LinkBacks
I would like the total of the Wait time columns to be shown in column AO. I tried a simple addition formula, but it doesn't work because of all the conditions. Can you help me?
I would like the total of the Wait time columns to be shown in column AO. I tried a simple addition formula, but it doesn't work because of all the conditions. Can you help me?
Try this, copied down...
=SUMIF($B$1:$AN$1,"Wait Time",$B2:$AN2)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Try this instead. It will ignore the "" values you have that are messing up the sum function.
=AGGREGATE(9,6,G2,J2,M2,P2,S2,V2,Y2,AB2,AE2)
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
@FDibbins I forget how nice the sumif function is. It works perfectly and makes more sense.
yes, it if a useful function to try 1st
Thanks for the feedback
You both rock. Thanks. It works great. SOLVED
Happy to help
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks