need help with formula for excel spreadsheet

[Rhonda Edwards]

I need help with a formula. If cells C12 through AG 12 have an "A" or an "F"
listed in a cell, I want to add and total the numbers in cells C13 through
AG13 in cell in AH (where I merged the cells 11-13). Then in AI I will be
totaling all the numbers in C13 through AG13 that have "T" listed in any cell
from C12 through AG 12. And so on. I have tried to figure this out from
reading the help menu in Excel but I haven't been able to; can someone help.
Thanks,

 

[Echo S]

You really need to post this question in one of the Excel groups.

 

[Stumped too]

could you change the particular search item to the number 1, the do a @sum?

 

[Helpful One]

If by "add and total the numbers" the OP means "sum" and ignoring the
unknown meaning of "merged the cells 11-13", here is one way I would do it
without creating a complex formula for cells AH13, AI13, and AJ13.

I would choose 2 rows outside the current rows of data to use as a "scratch
pad area", say for our purposes C32 through AG32 and C33 through AG33. Any
two rows will do that are not already used and you do not have to be able to
see them once the proper formula's are entered.
Insert in C32 "=IF(C12="A",C13,0)" and in C33 = "IF(C12="F",C13,0)" This
will insert the number from row 13 in one and only one of the new rows for
that column. Which of the two rows will be determined by whether the
corresponding row 12 for that column is a "A" or a "F".
Then copy C32:C33 into D32:AG32. This repeats the above process for each
cell in row 13 within the range of C13 to AG13.
Next enter the following formulas into cells AH13, AI13, and AJ13
respectively, =SUM(C13:AG13), =SUM(C32:AG32), and =SUM(C33:AG33).

Does that get you what you want?

 

[junie]

you can find this by typing "sum if" in the type a question for help box in
excel-


SUMIF


Adds the cells specified by a given criteria.

Syntax

SUMIF(range,criteria,sum_range)

Range is the range of cells you want evaluated.

Criteria is the criteria in the form of a number, expression, or text that
defines which cells will be added. For example, criteria can be expressed as
32, "32", ">32", "apples".

Sum_range are the actual cells to sum.

Remarks

The cells in sum_range are summed only if their corresponding cells in range
match the criteria.

If sum_range is omitted, the cells in range are summed.

Microsoft Excel provides additional functions that can be used to analyze
your data based on a condition. For example, to count the number of
occurrences of a string of text or a number within a range of cells, use the
COUNTIF function. To have a formula return one of two values based on a
condition, such as a sales bonus based on a specified sales amount, use the
IF function.

Example

The example may be easier to understand if you copy it to a blank worksheet.

How?

Create a blank workbook or worksheet.
Select the example in the Help topic. Do not select the row or column
headers.


Selecting an example from Help

Press CTRL+C.
In the worksheet, select cell A1, and press CTRL+V.
To switch between viewing the results and viewing the formulas that return
the results, press CTRL+` (grave accent), or on the Tools menu, point to
Formula Auditing, and then click Formula Auditing Mode.


1
2
3
4
5
A B
Property Value Commission
100,000 7,000
200,000 14,000
300,000 21,000
400,000 28,000
Formula Description (Result)
=SUMIF(A2:A5,">160000",B2:B5) Sum of the commissions for property values
over 160000 (63,000)


somebody, somewhere is willing to help if you ask!