herpasymplex10
Board Regular
- Joined
- May 26, 2005
- Messages
- 224
so I rec'd help on the below code
=IF(AND(OR(F2="F",F2="M"),right(D2,2)="AP"),L2,"")
I have this code in every cell of column M
and then at the bottom of column M I have a cell with the sum of the results
column M produced.
I saw the SUMIF function and was wondering if I could replace all these cells of formulas with just one by turning the above code to a SUMIF?
instead of F2 it would be the column F
and instead of right(D2,2)="AP"
it would be column (D, 2)="AP"
is this possible?
I've never used SUMIF before
=IF(AND(OR(F2="F",F2="M"),right(D2,2)="AP"),L2,"")
I have this code in every cell of column M
and then at the bottom of column M I have a cell with the sum of the results
column M produced.
I saw the SUMIF function and was wondering if I could replace all these cells of formulas with just one by turning the above code to a SUMIF?
instead of F2 it would be the column F
and instead of right(D2,2)="AP"
it would be column (D, 2)="AP"
is this possible?
I've never used SUMIF before