Help needed with a function
 

Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

Help needed with a function
 

Hi,

I don't understand. 4 colums of data summed in row 11 like this

1 3 4 5 *
2 4 3 4
3 5 5 5
4 6 6 3
5 76 7 6
6 5 5 7
7 4 6 5
8 3 4 3
9 23 3 3
8 54 4 3
53 183 47 44

A marker is enter in column 5. What is summed next and where?

Mike

"CP" wrote:

Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

Help needed with a function
 

"CP" wrote in message
...
Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in
A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

For column A (for example), use:
=SUMPRODUCT((E1:E10="*")*(A1:A10))

Help needed with a function
 

Don't use an asterisk for your marker, as this is the wildcard
character - suppose you use "Y" instead. Then in A11 you can use:

=SUMIF($E1:$E10,"Y",A1:A10)

Copy this into B11:D11. This will sum the values only where column E
contains a "Y".

Hope this helps.

Pete

On Nov 19, 11:15 am, CP wrote:
Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

Help needed with a function
 

On this example data is in column A and your marker is in column B. I'm
using * as the marker.

This will total values in column A where there is a marker in col B


=SUMPRODUCT((A1:A20)*(B1:B20="*"))


Rob

"CP" wrote in message
...
Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in
A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

Help needed with a function
 

That worked great - and the Y is better

"Pete_UK" wrote:

Don't use an asterisk for your marker, as this is the wildcard
character - suppose you use "Y" instead. Then in A11 you can use:

=SUMIF($E1:$E10,"Y",A1:A10)

Copy this into B11:D11. This will sum the values only where column E
contains a "Y".

Hope this helps.

Pete

On Nov 19, 11:15 am, CP wrote:
Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

Help needed with a function
 

Not sure if this will help but...

=SUMIF(E1:E11,"~*",A1:11)

Hope this helps,

Gav.

"CP" wrote:

Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great

Help needed with a function
 

You're welcome - thanks for feeding back.

Pete

On Nov 19, 11:41 am, CP wrote:
That worked great - and the Y is better



"Pete_UK" wrote:
Don't use an asterisk for your marker, as this is the wildcard
character - suppose you use "Y" instead. Then in A11 you can use:

=SUMIF($E1:$E10,"Y",A1:A10)

Copy this into B11:D11. This will sum the values only where column E
contains a "Y".

Hope this helps.

Pete

On Nov 19, 11:15 am, CP wrote:
Trying to something with excel (not an expert) and struggling

I have five columns with 10 rows
There is row 11 which is the sum of each row (ie A1 to A10 is totalled in A11)
What I want to do is place a marker in column five on any row and it show
the total of the column assuming column five has a marker.

example

10 20 30 40 *
10 20 30 40 *
10 20 30 40
10 20 30 40
20 40 60 80 Total row

I cannot figure out the function required for row 11
Not sure if that makes sense - any help would be great- Hide quoted text -

- Show quoted text -