Go Back   Tech Support Forum > Microsoft Support > Microsoft Office support

Excel help req'd - sumif but choose column?

This is a discussion on Excel help req'd - sumif but choose column? within the Microsoft Office support forums, part of the Tech Support Forum category. Hi I need some help in Excel 2007 with sumif. Imagine a fairly simple table as below: b 4 a


Closed Thread
 
Thread Tools Search this Thread
Old 04-29-2008, 06:34 PM   #1
Registered Member
 
Join Date: Jan 2008
Posts: 2
OS: Windows XP Professional



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?

__________________
ralwig88 is offline  
Old 05-05-2008, 07:51 PM   #2
Registered Member
 
Join Date: Jan 2008
Posts: 2
OS: Windows XP Professional



Anyone?
__________________
ralwig88 is offline  
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is on
Smilies are on
[IMG] code is on
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Post a Question


» Site Navigation
 > FAQ
  > 10.0.0.2


All times are GMT -7. The time now is 12:35 PM.


Copyright 2001 - 2014, Tech Support Forum

Windows 7 - Windows XP - Windows Vista - Trojan Removal - Spyware Removal - Virus Removal - Networking - Security - Top Web Hosts