formula for totalling columns based on data in rows in another column

Please post a file with sample data and expected results. (Many of use cannot view PNG files).

To upload a file, Click "Go Advanced" then "Manage Attachments".

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 go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Example.xlsx

Excel file attached

Hi,

I have now uploaded my example document as requested to help with my question, thanks

Hi, CraigFOD, I dont know if I Fully understand your problem, This might Help!

Please Login or Register  to view this content.

HI, thanks I've tested it but it doesn't work

Let me explain in more detail. So, I want to calculate how much profit I have quoted my customers, but only based on the quotes that went ahead. So if there is a value in column AA that means that the quote went ahead and turned into a sale. So for all of these "sales" I want to add up what the expected profit was which is in column V

The ones that did not turn into a sale therefore have no value in column AA and therefore the "Estimated Profit" in column V I do not want to add up.

So it's basically counting all of column V but ignoring the rows whereby the sale did not happen.

Does that make more sense?

Try

=SUMIF(AA:AA,"<>",V:V)

It works now how I wanted to, I just changed "Column AA does not Contain any value" in your formula to "0" then I can total this row

Brilliant, thank you !

Yes it will really work, Include this one too

Please Login or Register  to view this content.

to leave Cell V to Blank also, cause if your Coloumn AA is Blank, Cell V will Return Error. Try to past this in your Cell V, under cell with Value 49.00, then try to delete value in Cell AA (Value 4450).

Please Login or Register  to view this content.