|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
Thread Tools |
04-29-2008, 06:34 PM
|
#1 (permalink) |
|
Registered User
Join Date: Jan 2008
Posts: 2
OS: Windows XP Professional
|
Excel help req'd - sumif but choose column?
Hi
I need some help in Excel 2007 with sumif. Imagine a fairly simple table as below: b 4 a 3 b 5 b 2 c 1 a 8 c 9 I can run a sumif of all the "b"s to get a total of 11. However, in my example, say that the column of numbers is labelled "March 2008". Each month I get a new column of data - next month I'll have "April 2008" column of new numbers. I don't want to re-write the sumif each month - I want it to look up the date across the top and THEN look at the sumif of that particular column, based on the fixed set of letters in the first column. Any ideas? |
|
     
|
|
| Thread Tools | |
|
|
