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  
Sponsored Links
Advertisement
 
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 09:52 AM.


vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Copyright 2001 - 2015, Tech Support Forum

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

 

Partially Powered By Products Found At Lampwrights.com