| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If...rows and columns
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... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If...rows and columns
Use the below formula. It should be 24 ? isnt it..
=SUMIF(A1:A10,"A",B1:B10) -- If this post helps click Yes --------------- Jacob Skaria "something68" wrote: 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... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If...rows and columns
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 -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "something68" wrote in message ... 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... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
If...rows and columns
The formula works! Thank you so much, I love it!
"Jacob Skaria" wrote: Use the below formula. It should be 24 ? isnt it.. =SUMIF(A1:A10,"A",B1:B10) -- If this post helps click Yes --------------- Jacob Skaria "something68" wrote: 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... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i paste rows/columns avoiding hidden rows/columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
| how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) | |||
Linear Mode
