Sum cells based on 2 variable rules

[GenericPat]

Hey guys,

Another little dilema...

In column A I have numbers such as: 13252, 13232, 13712 etc...

In column B I have numbers such as: 12, 45, 145, etc...

Is there a way of adding every row that has a specific number in row A and a specific number in row B?

For example... I want to add all the totals in column C where the 13252's in column A have a number 12 tied to it in column B...

13252 12 100$
13252 12 250$
13252 23 75$
13232 120 150$
13712 120 275$

In this case my formula would first find column A (13252 for this example) then go on to column B (12 for this example) and add 100$ + 250$ = 350$

Also in this case the (13232 | 120) and (13712 | 120) would not be added together because they dont have the same number in column A...

Any help?

Thanks again,

Pat.

[Dave H9]

That would be SUMIFS() -

Please Login or Register  to view this content.

Dave H

[GenericPat]

Yes that function is ok but I have millions of data I dont want to specify what value to look for... I just want it to match A1 and B1 with A2 and B2 on its own and if they are equal then to add them together...

Understand?

[GenericPat]

Nevermind that actually worked like a charm!!!!!

[Dave H9]

I'm not sure I fully understand, but the specific values I posted in the formula can be replaced with cell references where you could specify the criteria you want. for example -

Please Login or Register  to view this content.

Where the formula would be in cell F1, D1 is the criteria for column A and E1 is the criteria for column B

Dave H

[GenericPat]

Ya I got it now... I didn't think it would copy the format to my other cells but it did without me having to change the criterias every time

Thanks alot bud!

Cheers,

Pat.

[Dave H9]

Glad to help

Dave H