Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function
Here is my problem
I want to sum the values in a column if they meet two criteria, see below: A B C D Site Vehicle Value 4 Wheeler Bardon Bardon 4 Wheeler 1000 Croft 4 Wheeler 2000 Bardon 4 wheeler 3000 In column D I want it to sum the value column if A equals Bardon and B equals 4 wheeler. I have done this with one column using the following: =SUMIF(T4:T47,"4 wheelers",F4:F47) can I use the AND function? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function
Hi
Try something like this: =SUMPRODUCT(--(A2:A100="Bardon"),--(B2:B100="4 Wheeler"),(C2:C100)) This function cannot use full columns as ranges and the ranges must all be the same size. Hope this helps. Andy. "Jo Davis" wrote in message ... Here is my problem I want to sum the values in a column if they meet two criteria, see below: A B C D Site Vehicle Value 4 Wheeler Bardon Bardon 4 Wheeler 1000 Croft 4 Wheeler 2000 Bardon 4 wheeler 3000 In column D I want it to sum the value column if A equals Bardon and B equals 4 wheeler. I have done this with one column using the following: =SUMIF(T4:T47,"4 wheelers",F4:F47) can I use the AND function? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function
Something like =SUMPRODuct((B4:B47="4 wheelers")*(A4:A47="Bardon"),F4:F47) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=545407 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function
Thanks that works a treat!!
"Andy" wrote: Hi Try something like this: =SUMPRODUCT(--(A2:A100="Bardon"),--(B2:B100="4 Wheeler"),(C2:C100)) This function cannot use full columns as ranges and the ranges must all be the same size. Hope this helps. Andy. "Jo Davis" wrote in message ... Here is my problem I want to sum the values in a column if they meet two criteria, see below: A B C D Site Vehicle Value 4 Wheeler Bardon Bardon 4 Wheeler 1000 Croft 4 Wheeler 2000 Bardon 4 wheeler 3000 In column D I want it to sum the value column if A equals Bardon and B equals 4 wheeler. I have done this with one column using the following: =SUMIF(T4:T47,"4 wheelers",F4:F47) can I use the AND function? |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUMIF function
Thanks for the feedback - glad you're sorted!
Andy. "Jo Davis" wrote in message ... Thanks that works a treat!! "Andy" wrote: Hi Try something like this: =SUMPRODUCT(--(A2:A100="Bardon"),--(B2:B100="4 Wheeler"),(C2:C100)) This function cannot use full columns as ranges and the ranges must all be the same size. Hope this helps. Andy. "Jo Davis" wrote in message ... Here is my problem I want to sum the values in a column if they meet two criteria, see below: A B C D Site Vehicle Value 4 Wheeler Bardon Bardon 4 Wheeler 1000 Croft 4 Wheeler 2000 Bardon 4 wheeler 3000 In column D I want it to sum the value column if A equals Bardon and B equals 4 wheeler. I have done this with one column using the following: =SUMIF(T4:T47,"4 wheelers",F4:F47) can I use the AND function? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I add and IF function to a SUMIF function? | Excel Worksheet Functions | |||
SUMIF Function Inside SUMPRODUCT Function | Excel Worksheet Functions | |||
SumIF function | Excel Discussion (Misc queries) | |||
Sumif function with remote cell references | Excel Worksheet Functions | |||
SUMIF function | Excel Worksheet Functions |