Hello Gurus,
I am trying to figure out the formulas to use when I change the Input Site# it gives me the suite count for that particular site based on data in another worksheet.
So I need the suite count based on the data and zeros where there is not suite type.
Attached is a sample of data to help figure out the formula. Hope this makes sense. If not let me know and I will try my best to explain in more detail if I can.
Your help is appreciated.
Thanks.
Hi -
Copy and paste this formula into Cell F4 and copy across.
=SUMIFS($G$10:$G$13,$E$10:$E$13,$B$2,$F$10:$F$13,F2)
Hope this helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Or (especially if there is a chamce that also someone with older version of excel will use the file) in F4:and copy rightFormula:
Please Login or Register to view this content.
Best Regards,
Kaper
Works like a charm!
Thank you loginjmor and thanks Kaper. You guys are fantastic!
Great! Glad we could help! Thanks for the rep. Please don't forget to mark this thread as SOLVED per the instructions at the bottom of this post!
Glad to hear that and thanks for marking thread solved and for reputation point :-)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks