SUMIF?
If a row contains more than one entry that meets the criteria should that be
calculated as n*I ?
Like this:
xxxA...xxxc...cccA...5
The row contins 2 entries that end in "A". So, should the result add 2*5 =
10 to the total?
--
Biff
Microsoft Excel MVP
"Perry" wrote in message
...
Here is my situation
I have a data range that contains a six-character value. I only care about
the last character
I want to sum the values in I4:I29 where the characters in A4:H29 meet a
certain value
EX: A4 = A00000A; I4 = 2
B10 = B11111A; I10=1
G5 = C12121A; I5 = 1
H29 = D12345A; I5 = 4
I want the sum of the values in I (8) for these cells but not for any
others.
I have tried:
=IF(A4:H29="*A",SUM(I4:I29),0)
=SUMIF(A4:H29, "*A", I4:I29)
=SUM(IF(((A4:A29="*A")+(B4:B29="*A")+(C4:C29="*A") +
(D4:D29="*A")+(E4:E29="*A")+(F4:F29="*A") +(G4:G29="*A")), SUM(I4:I29),0)
=IF(RIGHT(A4:A29)="N",SUM(I4:I39),0)
All of the above formulas return the value 0 (false)
On the same worksheet the following formula works:
COUNTIF(A4:H29,"*A")
Any suggestions?
|