Sumif using 2 conditions

  • Thread starter Thread starter Rusty_nl
  • Start date Start date
R

Rusty_nl

Ok I am new here, so be gentle. ;)

I will try to explain what I am trying to do as best as possible.

I have a table with with sevel colums.

TECHTOT|1200|TECHBI|300|TECHIND|400|TECHCHAN|900

| is a colum seperator.

These colums go down for several hundred rows with different dat
against them ofcourse.

Now to calculate some bonus payments I need to do a sum of 2 of thos
colums. However the colums change per calculation

So let me try and make clear what I am trying to do:

Person1: should recieve the total of TECHTOT and TECHBI
Person2: should recieve the total of TECHTOT and TECHCHAN

So the table for that bit will look like this:

Person1|TECHTOT|TECHBI|"sum of those 2"
Person2|TECHTOT|TECHCHAN|"sum of those 2"

I have tried using 2 sumifs and adding the 2. But that doesnt work as
sumif will only check the first colum of the array its looking in.

I have also tried using nested IF statements combined with SUMIF
However this didnt work for some reason that I have figured out yet.
guess I am using to many nested IF and SUMIF functions.

Does any one have any idea what I could try
 
Hi
is the person also a column in your data. If not why not use for person
1
=SUM(A1:A1000)+SUM(C1:C1000)

and for person 2
=SUM(E1:E1000)+SUM(G1:G1000)
 
The person name is also a colum and since the number of differen
persons is rather big I would prefer not to do it this way.

Also looking forward the setup might change and if I can automate th
lookup it would save alot of time
 
Hi
one question:
if you have several person how to you know which values/columns you
have to sum up for a specific person?
 
The 2 colums next to the persons name define the values and columns tha
I want to do the sumif on.

Hope that makes it clearer what I am trying to achieve.

And before I forget, thanks alot for your help and time already. Thi
forum is great

Frank said:
*Hi
one question:
if you have several person how to you know which values/columns you
have to sum up for a specific person?

--
Regards
Frank Kabel
Frankfurt, Germany

Click to expand...
 
Hi
If you like email me your file (frank[dot]kabel[at]freenet[dot]de) as I
still don't understand your spreadsheet layout
But that's probably me :-)

--
Regards
Frank Kabel
Frankfurt, Germany
The 2 colums next to the persons name define the values and columns
that I want to do the sumif on.

Hope that makes it clearer what I am trying to achieve.

And before I forget, thanks alot for your help and time already. This
forum is great

Frank said:
*Hi
one question:
if you have several person how to you know which values/columns you
have to sum up for a specific person?

--
Regards
Frank Kabel
Frankfurt, Germany

Click to expand...
Click to expand...
 
Back
Top