lookup from one column return value from another?

  • Thread starter Thread starter Maria
  • Start date Start date
M

Maria

I want to check the value of one column (A) and then depending on the
outcome add the value in the same row but column B to a total. Can I do this
in a single cell formula or do I have to have an extra column that does the
logic test and then a cell to do the totalling?
 
Hi Maria

not sure of exactly what you want
but does
=IF(A1="Fred",B1,0)
give you what you want? if not could you type out an example of your data
and what you want to see (please don't attach a workbook just type it out)

--
Cheers
JulieD

check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
 
You must log in or register to reply here.

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

Help needed 0
Excel Help to copy information from one row at a time to another sheet 1
3 Similar formulas, one returns #VALUE! 4
Excel Subtracting multiple columns from another column 3
lookup using column headers and row headers 1
how to return an address from a lookup into a table? 7
How fill series containing one variable and one fixed value in XL 1
Lookup returning #n/a 1

Back
Top