Microsoft Office Forums
>
Microsoft Excel
>
Excel
Using IF
User Name
Remember Me?
Password
Register
FAQ
Mark Forums Read
Thread Tools
Display Modes
#
1
11-14-2010, 09:24 AM
nfphilpot
Windows XP
Office 2007
Novice
Join Date: Nov 2010
Posts: 7
Quote:
Originally Posted by
Kimberly
or better yet, enter a unique list of the names in Col J for example, and put this in K1
=SUMIF($A$1:$A$5,J1,$B$1:$B$5)
and copy down for all the names
Would you mind giving me a quick example of this...cant figure exactly what you mean...
...thanks to the above formula, works a treat!
nfphilpot
View Public Profile
Find all posts by nfphilpot
«
Previous Thread
|
Next Thread
»
Thread Tools
Show Printable Version
Email this Page
Display Modes
Switch to Linear Mode
Hybrid Mode
Switch to Threaded Mode
Other Forums:
Access Forums
All times are GMT -7. The time now is
09:59 AM
.
-- Default Style
-- Lightweight
-- New Mobile
Contact Us
-
Privacy Statement
-
Top
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by
DragonByte SEO (Lite)
-
vBulletin Mods & Addons
Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft