How do I get excel to do the equivalent of this...

  • Thread starter Thread starter chrisjleu
  • Start date Start date
C

chrisjleu

How do i get excel to do the equivalent of this:

Here's a fragment of my spreadsheet:

Expense Code Amount
1 £10.00
2 £50.00
1 £10.00
3 £80.30
1 £10.00
2 £15.00
1 £100.00
1 £12.00

I want to sum all the values where expense code = x

I thought I might use VLOOKUP and SUM but it doesn't appear to be
working. Can anyone help?

Thanks.
 
With the code in column A and the price in column B
=SUMPRODUCT((A1:A1000=1)*(B1:B1000))
Regards,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vlookup and Hlookup 3
Excel SUMIF formula statisfying two conditions 8
How do I compare in between two worksheets? 1
combine vlookup and match help 5
Excel formular to Count values in cells of rows that meet criteria 7
Matching check to payment amounts 7
Using two values for lookup 5
Function IF statement 11

Back
Top