Greetings,
I'm trying to use the sumif function in excel 2010 to find a row in a worksheet then only sum certain columns in the row. Below is sample date and the formula I'm currently using.
Example data:
Column: A B C D....
Row 1: Account#, period 1, period 2, period 3....
Row 2: 105320410, 10, 20, 30...
=SUMIF(A1:D2,105230410,C1:D2)
The result is only the first cell in the range, or 20, instead of the desired result of 50.
Thanks in advance for your help.
Last edited by mennojim; 09-22-2010 at 05:09 PM.
Try perhaps:
=SUMPRODUCT((A1:A2=105230410)*C1:D2)
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks for the suggestion. The result is a #VALUE. I'll keep working on a solution, but I attached a sample sheet with the formula it you have time to take a look.
Again, thanks...
Jim
Are you working on one line only?
If so, then:
=IF(A2=105230410,SUM(C1:D2))
in not, then don't include the headers.. with this Sumproduct formula, the summing range should not include any text entries.... so start ranges at A2...
Yes I will have more than one row. So leaving the header our of the range did it. Many thanks...
Re: SUMIF with Horizontal sum range
ATTACHMENT: SumProductTest.xlsx
I am having a bear of a time with this...
I get #VALUE! every time.
Here, I'm trying to get the sum of values in a SINGLE ROW, but for ALL COLUMNS LESS THAN A SPECIFIED VALUE.
Attached is the example, but the formula is
Sample Data:
Please Login or Register to view this content.
Please Login or Register to view this content.
Hello gotmike,
welcome to Excel Forum........but please post this as a new thread rather than "hijacking" an old thread - thanks
Audere est facere
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks