Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the sum of a row based on condition of a dropdown box
how do i sum a row of vallues based on the condition that the text value in a
dropdown box in a row above it. for example a b a d a d a total-a total-b total-d 1 1 1 1 1 1 1 4 1 2 the letters are a row of drop down boxes whose values can be text. i have in the drop down boxes types of leave (annual, sick, famil, etc). at the end i have totals for each kind of leave. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the sum of a row based on condition of a dropdown box
take a look at the SUMIF function, I belive it's exactly what you're looking
for. =SUMIF(A1:D1,"a",A2:D2) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "AHMED" wrote: how do i sum a row of vallues based on the condition that the text value in a dropdown box in a row above it. for example a b a d a d a total-a total-b total-d 1 1 1 1 1 1 1 4 1 2 the letters are a row of drop down boxes whose values can be text. i have in the drop down boxes types of leave (annual, sick, famil, etc). at the end i have totals for each kind of leave. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
the sum of a row based on condition of a dropdown box
Thank you so much. It worked perfectly
-- AHMED "Luke M" wrote: take a look at the SUMIF function, I belive it's exactly what you're looking for. =SUMIF(A1:D1,"a",A2:D2) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "AHMED" wrote: how do i sum a row of vallues based on the condition that the text value in a dropdown box in a row above it. for example a b a d a d a total-a total-b total-d 1 1 1 1 1 1 1 4 1 2 the letters are a row of drop down boxes whose values can be text. i have in the drop down boxes types of leave (annual, sick, famil, etc). at the end i have totals for each kind of leave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I have a row copy to another worksheet based on dropdown v | New Users to Excel | |||
Dropdown list with a condition | Excel Discussion (Misc queries) | |||
Sum If based on a 3rd condition ? | Excel Worksheet Functions | |||
Dynamic Forumlas based on Dropdown | Excel Discussion (Misc queries) | |||
offer dropdown options based on another dropdown | Excel Discussion (Misc queries) |