Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with 2 conditions
I have a spreadsheet with 3 columns:
A Blue 250 B Blue 100 B Blue 300 C Red 500 A Red 200 A Blue 50 How could I use sumif to calculate all the A and blue in one cell and A and red in another cell. I do not want to use pivot tables. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with 2 conditions
Assume data in A1:C6
List the letters across in F1, G1,... : A, B, C List the colours in E2 down: Blue, Red Then put in F2: =SUMPRODUCT(($A$1:$A$100=$F$1)*($B$1:$B$100=$E2),$ C$1:$C$100) Copy F2 across and fill down to populate the grid Adapt the ranges to suit Note that we can't use entire col refs in SUMPRODUCT -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Anat" wrote in message ... I have a spreadsheet with 3 columns: A Blue 250 B Blue 100 B Blue 300 C Red 500 A Red 200 A Blue 50 How could I use sumif to calculate all the A and blue in one cell and A and red in another cell. I do not want to use pivot tables. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with 2 conditions
Assume data in A1:C6
should read: Assume data in A1:C100 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with 2 conditions
Thanks Max that worked.
"Max" wrote: Assume data in A1:C6 should read: Assume data in A1:C100 -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumif with 2 conditions
You're welcome, Anat !
Thanks for the feedback .. -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Anat" wrote in message ... Thanks Max that worked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF function with 2 conditions | Excel Worksheet Functions | |||
SUMIF based on two conditions | Excel Worksheet Functions | |||
SUMIF with two conditions | Excel Discussion (Misc queries) | |||
sumif with two conditions | Excel Worksheet Functions | |||
SUMIF based on 2 conditions | Excel Worksheet Functions |