hi everyone,
I export the results of a ms access query into excel (that’s how management wants it)
In excel I need to do some conditional addition; I'm not sure how to go about it.
X Y Z
1 S 7
2 r
3 S 8
4 r
I want to be able to Sum the Z values of the rows where the X value = S.
I am going to have to do the same for the r value after.
any suggestions on the best way to go about this?
thanks,
Sean
I export the results of a ms access query into excel (that’s how management wants it)
In excel I need to do some conditional addition; I'm not sure how to go about it.
X Y Z
1 S 7
2 r
3 S 8
4 r
I want to be able to Sum the Z values of the rows where the X value = S.
I am going to have to do the same for the r value after.
any suggestions on the best way to go about this?
thanks,
Sean