I have 2 columns, Column A and Column B. In column A is a total in £. Column B is a Yes/No column. I need to calculate all the totals which have a Yes next to them in Column B. I know i could just do a straight forward calculation using =sum but these columns will be changing frequently every month, so need a long term solution rather than keep having to change which cells i need to be calculating.
Any help will be much appreciated, thanks very much!!
Dan...
Hi,
Try this:
=SUMIF(B:B,"Yes",A:A)
Please disregard anything in the above post. It may well have been edited without my consent, as has been the case with several posts and threads recently.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks