If...rows and columns

S

something68

I would like to know what type of formula I would use for the following:

A1, A5, A10 contain "A"; A3, A4, A7 contain "P"; A6 contains "S"
B1, B5, B10 contain "8.0"; B3, B4, B7 contain "8.0"; B6 contains "4.0"

How can I show in A11, all "A" = 16 (because of B1, B5, B10)?

Or is this too confusing? I have an excel sheet ready as an example...
 
B

Bernard Liengme

This formula =SUMIF(A1:A10,"A",B1:B10) is read as: look at A1:A10 , locate
cells with "A", and add all corresponding B values. But the answer is 24
(=8+8+8). Where is your 16 coming from?
best wishes
 

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

Alpha sorting (with a twist...?) 3
formula that writes to a *different* cell? 4
PLEASE HELP TO MATCH ALL SHEET AND THEN MERGE, 1
Stripe out duplicate data 5
Bringing together data 4
Find the number of the lowest filled row 3
count distance in column 4
sort and sum data range with some blank cells 1

Top