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

Hi there,

What I have understood that you are trying to get the corresponding count against each value if the next cell is containing "x".

Please see image in line if it solve your purpose.

I have taken value in column "B" and text containing "x" in column "C". Then I looked up for the criteria.

countif.png

COUNTIF will do just that - count stuff.

I think what you need is sumif(). Something like...
=sumif(C:C,"x",B:B)

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))

Agreed with @FDibbins kindly upload your data in excel file as picture may not give much clarity.

It sounds that you wanted to have sum in the same column at the last row of each column starting from D. Type Following Formula

I am Assuming you have data starts B3 to K20 (As rows number are hidden )

Grand Total in D22 - Type :

Formula:

Please Login or Register  to view this content.

and drag it to the right till column K.

Hope this is what is what you are looking for.



Cheers!!!

Anil Dhawan

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

adhawan06, thank you so much for the kind words and rep points, much appreciated

Hey there,

If your query has been resolved, mark this thread as SOLVED and say thanks to those who helped you by adding *Add Reputation.

Thanks,
Anil Dhawan

Originally Posted by excelstone

Dineth... question on your pivot table comment.

I'm a new when it comes to excel, is there a step a b c for pivot tables. something that is less techie or is this a VBA coding thing?

PT's are generally pretty simple.

1. make sure all your data have headings
2. Make sure there are no empty columns (Add a dummy heading if there are)
3. Highlight the range
4. Select Pivot Table from the Insert tab
5. play around with the table by drag/drop headings into columns and rows

step by step on setting up a pivot table

http://www.excel-easy.com/data-analy...ot-tables.html