| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum if value above is X
Hi All
I am having trouble writing a formula to Sum the value of row 3 if the Cell above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the Sum of all of row 3 with an X above is only 350...? Im sure there is a simple formula out there..... A B C D E F G 1WK 46 47 48 49 50 51 52 2 X X X X 3 149 162 128 88 94 87 81 2 = 350 3 = 788 -- Thank you Neil |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum if value above is X
Try this:
=SUMIF(A2:G2,"X",A3:G3) -- Biff Microsoft Excel MVP "Neil" wrote in message ... Hi All I am having trouble writing a formula to Sum the value of row 3 if the Cell above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the Sum of all of row 3 with an X above is only 350...? Im sure there is a simple formula out there..... A B C D E F G 1WK 46 47 48 49 50 51 52 2 X X X X 3 149 162 128 88 94 87 81 2 = 350 3 = 788 -- Thank you Neil |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum if value above is X
MVP is right.
It worked a like a dream and simple thanks for the help.... -- Thank you Neil "T. Valko" wrote: Try this: =SUMIF(A2:G2,"X",A3:G3) -- Biff Microsoft Excel MVP "Neil" wrote in message ... Hi All I am having trouble writing a formula to Sum the value of row 3 if the Cell above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the Sum of all of row 3 with an X above is only 350...? Im sure there is a simple formula out there..... A B C D E F G 1WK 46 47 48 49 50 51 52 2 X X X X 3 149 162 128 88 94 87 81 2 = 350 3 = 788 -- Thank you Neil |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum if value above is X
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Neil" wrote in message ... MVP is right. It worked a like a dream and simple thanks for the help.... -- Thank you Neil "T. Valko" wrote: Try this: =SUMIF(A2:G2,"X",A3:G3) -- Biff Microsoft Excel MVP "Neil" wrote in message ... Hi All I am having trouble writing a formula to Sum the value of row 3 if the Cell above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the Sum of all of row 3 with an X above is only 350...? Im sure there is a simple formula out there..... A B C D E F G 1WK 46 47 48 49 50 51 52 2 X X X X 3 149 162 128 88 94 87 81 2 = 350 3 = 788 -- Thank you Neil |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sum if value above is X
Neil wrote:
Hi All I am having trouble writing a formula to Sum the value of row 3 if the Cell above it in row 2 has an X above it, the Sum of all of row 3 is 788 but the Sum of all of row 3 with an X above is only 350...? Im sure there is a simple formula out there..... A B C D E F G 1WK 46 47 48 49 50 51 52 2 X X X X 3 149 162 128 88 94 87 81 2 = 350 3 = 788 =SUMIF($B$3:$H$3,"X",$B$4:$H$4) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
