Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sum with two critera?
How do I create a formula to SUM but SUM IF against two seperate criteria.
|
#2
|
|||
|
|||
Hi!
Need details! Be specific! Details, people! Details! <g Biff "Clare" wrote in message ... How do I create a formula to SUM but SUM IF against two seperate criteria. |
#3
|
|||
|
|||
One way is to use the sumproduct formula:
http://www.xldynamic.com/source/xld....T.html#explain "Clare" wrote: How do I create a formula to SUM but SUM IF against two seperate criteria. |
#4
|
|||
|
|||
Hi, this is also one answer that I am waiting for with baited breath, because
I am fond of the sumif function, which only has one criteria, somehow there must be a way to adapt this function to accept two criteria, come on guys "Biff" wrote: Hi! Need details! Be specific! Details, people! Details! <g Biff "Clare" wrote in message ... How do I create a formula to SUM but SUM IF against two seperate criteria. |
#5
|
|||
|
|||
Good afternoon guys OK, this is how it's done A B C Product 1 Manchester 10 Product 1 London 15 Product 2 Manchester 12 Product 1 London 20 Product 1 London 25 Product 2 London 11 Product 1 Manchester 8 Product 2 Manchester 6 Product 1 Manchester 5 Product 1 Manchester 4 This formula will add up all the occasions where column A=product 1 and column B = Manchester. =SUM(IF($A$2:$A$11="Product 1",IF$B$2:$B$11="Manchester",$C$2:$C$11,0),0)) Just remember it's an array formula so to commit it use ctrl + alt + enter. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=398490 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i copy rows using critera in a formula? | Excel Worksheet Functions |