SUMIF?
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:C 29=*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?
|