Hello.
I really hope this is going to make sense ...
I need a formula to calculate the B and X lines, but only count them if there is a X in the same row.
I have a formula that will count the B but instead of having 2 x b/x and 1 x b it is adding it all up so my counts are 2 x b/x & 3 x b, this is inaccurate for my reporting.
Thanks for your help.
Bookmarks