View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Patti Patti is offline
external usenet poster
 
Posts: 45
Default Creating a Function in Excel 2003

I have a spreadsheet that first breaksdown expenses, between centers, ie
project or ministry, then secondly by expense type, ie cash or credit card,
then I need it to sum the column with actual $. I've tried to use the IF
function but I get error message...

=IF(D8:D99="x", IF(F8:F99="x",SUM(H8:H99)))

Can anyone please help me...

Thanks so much
--
Patti Lassiter