Trouble using =SUMIF

On my work we have worksheets that are linked togheter and alle employees put an X in one cell each day they are present at work. Now I would like to make aformula that will show everyone how much over/below budget thay are regarding their sales.



IE:
A2 => A31 are all possible days to come in to work in june, and the salepeople will mark with x when they have been in. In Cells A1:A31 there is value 1. Cells C1:C31 they will put an x each day present at work.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Thanks for taking the time to read and comply with the rule .

Have a look at SUMIF or COUNTIF in Excel help files...

e.g. = SUMIF(A1:A100,"x",B1:B100) will sum values in B1:B100 where A1:A100 may have an "x".

or =COUNTIF(A1:A100,"x") will count the number of "x" in A1:A100... then you can multiply that result by a "budget" number.

If this does not suit your needs or you have further questions, please post a sample workbook depicting your requirements.

Originally Posted by NBVC

Have a look at SUMIF or COUNTIF in Excel help files...

e.g. = SUMIF(A1:A100,"x",B1:B100) will sum values in B1:B100 where A1:A100 may have an "x".


If this does not suit your needs or you have further questions, please post a sample workbook depicting your requirements.

Thx a lot.

In the workbook cell A1 to A31 is hidden but each A cell holds value 1. Cell C1 to C31 is marked with an x where the employees have been in for work.
What I need is to sum cell A1:A31 but only where there is an x in a related C cell. I tried your formula but get an error and I can not figure out why.

This is what I tried: = SUMIF(C1:C31,"x",A1:A31) and also I turned it around: = SUMIF(A1:A31,"x",C1:C31) but I get error. What is wrong here?

based on your region (Scandinavia) try changing the comma to semi colon

=SUMIF(C1:C31;"x";A1:A31)

That said if A always holds 1 you could actually use COUNTIF

=COUNTIF(C1:C31;"x")

You don't need to use any helpers... just use the COUNTIF as advised.