the sum of a row based on condition of a dropdown box

A

AHMED

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.
 
L

Luke M

take a look at the SUMIF function, I belive it's exactly what you're looking
for.

=SUMIF(A1:D1,"a",A2:D2)
 

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

Top