Formula to only add the quantities in a column against a certain criteria in the next column

Hi Experts

Probably an easy one but my brain isnt working today so help is required

There are two columns inside a spreadsheet, the one has a calculation in it and the next column has a simple yes or no against certain figures

How do I get the column with figures just to add the items with yes against them.

Many Thanks
J
Jase AlexanderCompliance ManagerAsked:
Who is Participating?
 
MichaelConnect With a Mentor Business AnalystCommented:
Hi,

you can use SUMIF:

=SUMIF(B2:B100,"yes",A2:A100)

where B2:B100 is the range of yes and no
and A2:A100 is the range to be summed
0
 
Gašper KamenšekExcel MVPCommented:
You format your data as a table, add a total row and say you want to sum in the figures column. To just get those figures, you would use filter and filter by another column and show only those with yes...

See attached

yes.xlsx

Hope this helps..
0
 
Jase AlexanderCompliance ManagerAuthor Commented:
AH briliant !!

Many Thanks
J
0
All Courses

From novice to tech pro — start learning today.