sum if adjacent cell empty or 0

[DHayes]

Good day,
I have been struggling to calculate the below. What I would like to calculate is if T is blank or 0 and A is equal 1. I need to know the sum. I have been trying with Sumif, sumproduct and countif without success. in the below example the answer should be 3. Any help will greatly be appreciated.

[TABLE="class: grid, width: 960, align: center"]
<tbody>[TR]
[TD]T
[/TD]
[TD]A
[/TD]
[TD]T
[/TD]
[TD]A
[/TD]
[TD]T
[/TD]
[TD]A
[/TD]
[TD]T
[/TD]
[TD]A
[/TD]
[TD]T
[/TD]
[TD]A
[/TD]
[TD]T
[/TD]
[TD]A
[/TD]
[TD]T
Total[/TD]
[TD]A
Total[/TD]
[TD]O
Only A not T[/TD]
[/TR]
[TR]
[TD]
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]
[/TD]
[TD]1
[/TD]
[TD]1
[/TD]
[TD]
[/TD]
[TD]
[/TD]
[TD]1
[/TD]
[TD]3
[/TD]
[TD]4
[/TD]
[TD]3
[/TD]
[/TR]
</tbody>[/TABLE]

 

[dallenk]

here is one idea, might need to play with it a little... formula for:

T Total: =SUM(COUNTIFS($A$2:$L$2,"T",A3:L3,{"",0}))
A Total: =SUM(COUNTIFS(A2:L2,"A",A3:L3,"1"))

not sure on the only A not T cell.. trying a couple things..

 

[DHayes]

Thank you for your feedback dallenk.
Soon after I posted something clicked. I used the below and works great.

=SUM(N2-(SUM(IF(FREQUENCY(IF(A1:L1="A",IF(A2:L2=1,A2:L2)),A2:L2)>0,1))))

Use CTL+SHIFT+ENTER

 

[DHayes]

After doing multiple tests My formula does not work. Any assistance will be appreciated.

 

[DHayes]

Thank you Dallenk,
This one is working great much appreciated.

=SUM(COUNTIFS($A$2:$L$2,"T",A3:L3,{"",0}))

 

[DHayes]

Please help here. I thought I had the solution but to no avail. All I need to calculate is how many where A=1 and T=""or 0. It is driving me crazy. (See Post 1)

 

[Finalfight40]

How about this? (You may need to adjust ranges)

=SUM(IF((A1:L1="T")*(A3:L3=0), OFFSET(A3:L3, 0, 1), 0))

Entered as an array with ctrl + shift + enter.

 

[DHayes]

Thank you so much it works great. Appreciated

 

[Finalfight40]

Glad it works for you