Help with SUMIF & AND function

M

mirko

Hi, how do I create a formula to sumarize value by group and subgroup? My
formula by group works but unfortunately the 2nd one doesn't work.
What I need is : sumarize the value (column D ) of all products having group
= A and subgroup = A.
total
group subgroup value by_gr by_subgr
A A 10
A A 20
A B 30
B A 40
B A 50
B B 60
C A 70
C B 80
D A 90
D B 10 60 =SUMIF(A2:A12;"A";C2:C12) this is OK
total 460

something like this: =SUMIF(A2:A12;"A".... AND ...B2:B12;"A";C2:C12) ???

Thanks in advance,
mirko
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Condense data for stock ordering 4
Make a mekko chart in Excel 2007 in three easy Steps 1
Avoiding auxiliary cells 0
sumif 1
Help with lots of formulas 3
SumIF 2
countifs Function not giving desired result with date criteria 2
Max/Min per item from a changing list 0

Top