Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif data from multiple columns
I need to do this:
A B D F H 32 3 2 3 4 44 3 3 2 3 Column A is a Length of material, Coulmns b, c, d, etc are how many pieces apply to that length for a given type of material. There is an additional material that holds three bars. So I need to know how many bars total I would need based on this. Example that doesn't work: =SUMIF(F5:F23,H5:H23,J5:J23,L5:L23,N5:N23,P5:P23," =3",C5:C23) Not thinking too hard, just hope someone has an answer |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif data from multiple columns
I don't quite understand what you are trying to do - can you re-
phrase? Pete On May 6, 3:18*am, Nick wrote: I need to do *this: A * * * * * * * * * * * * B * * * * * * * * * * * * * *D * * * * * * * * * * * * F * * * * * * * * * *H 32 * * * * * * * * * * * 3 * * * * * * * * * * * * * * *2 * * * * * * * * * * * * * 3 * * * * * * * * * * *4 44 * * * * * * * * * * * *3 * * * * * * * * * * * * * * 3 * * * * * * * * * * * * * 2 * * * * * * * * * * * 3 Column A is a Length of material, Coulmns b, c, d, etc are how many pieces apply to that length for a given type of material. There is an additional material that holds three bars. So I need to know how many bars total I would need based on this. Example that doesn't work: =SUMIF(F5:F23,H5:H23,J5:J23,L5:L23,N5:N23,P5:P23," =3",C5:C23) Not thinking too hard, just hope someone has an answer |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif data from multiple columns
It's difficult to determine your data layout.
What are the references to columns J, L, M and P in your formula? Dave url:http://www.ureader.com/msg/104233407.aspx |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif data from multiple columns
Sorry guys that was an exapmle out of another spreadsheet. I want to find the
number "3" in every other column in my spreadsheet starting with coulumn "b", add the count of occurences in a given row and multiply by the length in column A, and recieve a total for all rows. Does that help? "Dave Curtis" wrote: It's difficult to determine your data layout. What are the references to columns J, L, M and P in your formula? Dave url:http://www.ureader.com/msg/104233407.aspx |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sumif data from multiple columns
Try this:
=SUMPRODUCT((MOD(COLUMN(B1:E5),2)=0)*(B1:E5=3)*A1: A5) Adjust ranges to suit. As written, it tests B1:B5 and D1:D5 for the number 3. -- Biff Microsoft Excel MVP "Nick" wrote in message ... Sorry guys that was an exapmle out of another spreadsheet. I want to find the number "3" in every other column in my spreadsheet starting with coulumn "b", add the count of occurences in a given row and multiply by the length in column A, and recieve a total for all rows. Does that help? "Dave Curtis" wrote: It's difficult to determine your data layout. What are the references to columns J, L, M and P in your formula? Dave url:http://www.ureader.com/msg/104233407.aspx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIf Problem...trying to sum multiple columns | Excel Worksheet Functions | |||
Sumif Multiple Columns | Excel Worksheet Functions | |||
SUMIF and multiple columns | Excel Discussion (Misc queries) | |||
SUMIF over multiple columns | Excel Worksheet Functions | |||
Sumif over multiple columns | Excel Worksheet Functions |