I need a formula to count each x as a value, totaled below.

Originally Posted by FDibbins

Please upload a sample of your workbook, not a picture of your data. Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum

Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.

It sounds though, that you need something like...

=sumif(D:D,"X",C:C)

If you need to do that for specfic clients, then something like this instead...

=sumifS(C:C,D:D,"X",K:K=K2))

Hi Ford,

Just wanted to quick check, if I use formula given by you in D20, then the function will return to circular reference? correct me if i am wrong. As per my knowledge, you can't type an formula in the same column or row which you are considering as criteria. Please correct my understanding.

Thanks,

Originally Posted by adhawan06

Hi Ford,

Just wanted to quick check, if I use formula given by you in D20, then the function will return to circular reference? correct me if i am wrong. As per my knowledge, you can't type an formula in the same column or row which you are considering as criteria. Please correct my understanding.

Thanks,

Yes, you are absolutely correct. I could not see the sample pic provided, I can now. So my suggestion needs to be adjusted so that the range is not a full column range, but is, instead, the specific range covering the data