Vlookup & Sum Functions

[Nikki72]

I am trying to create a summary worksheet from another worksheet in a
workbook. I'd like to combine a sumif and vlookup funcion.

I need to referernce one sheet and say if certain value is in two columns
sum the data.

........a........b..........c............d
1..client....fund.....date....amount
2....x........abc.......1/08....$40
3....y........def........1/08....$50
4....z........abc........1/08....$100

I'm not sure how to write the formula. Any help would be appreciated!

 

[Tom [Pepper] Willett]

Try an Excel newsgroup. It's not a FrontPage issue.
--
Tom [Pepper] Willett
Microsoft MVP - FrontPage
---------------------------
:I am trying to create a summary worksheet from another worksheet in a
: workbook. I'd like to combine a sumif and vlookup funcion.
:
: I need to referernce one sheet and say if certain value is in two columns
: sum the data.
:
: .......a........b..........c............d
: 1..client....fund.....date....amount
: 2....x........abc.......1/08....$40
: 3....y........def........1/08....$50
: 4....z........abc........1/08....$100
:
: I'm not sure how to write the formula. Any help would be appreciated!
:
: