Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I SUMIF between rows rather than columns?
I need to sum the values in one row, but only if the corresponding values in
a second row fulfil a criteria. e.g. With a budget laid out with a column for each month in 2010: for each month sum "Cost A" if "Income type 1" 0. Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I SUMIF between rows rather than columns?
Hi,
From your description I'm struggling to undertsnad you data layout but maybe this =SUMIF(A2:L2,"0",A1:L1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Robnarc" wrote: I need to sum the values in one row, but only if the corresponding values in a second row fulfil a criteria. e.g. With a budget laid out with a column for each month in 2010: for each month sum "Cost A" if "Income type 1" 0. Thanks! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I SUMIF between rows rather than columns?
Mike,
The OP is looking for missing names in column B but present in A, you neat method seems to locate names missing in column A compared to B best wishes Bernard "Mike H" wrote in message ... Hi, From your description I'm struggling to undertsnad you data layout but maybe this =SUMIF(A2:L2,"0",A1:L1) -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Robnarc" wrote: I need to sum the values in one row, but only if the corresponding values in a second row fulfil a criteria. e.g. With a budget laid out with a column for each month in 2010: for each month sum "Cost A" if "Income type 1" 0. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIf across columns instead of rows | Excel Worksheet Functions | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
SUMIF with rows and columns | Excel Worksheet Functions | |||
sumif columns and rows | Excel Worksheet Functions |