LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default Help with a formula

I'm hoping somenone can help me. I know I know how to do this, but it's not
clicking for me at the moment. I need a formula to do the following:

I need X21 to calculate the total if B19="x" and B21="x" then W19+P21, but
if B21=" " then W19.

I need X28 to calculate the total if B25="x" and B28="x" then W25+P28, but
if B28=" " then W25.

I need X32 to calculate the total if B32="x" and B35="x" then W32+P35, but
if B35=" " then W32.

I need T38 to equal the sum of X21+X28+X32.

I can get the last part, but when I try the first formula, I keep getting
error messages. Can anyone help? I'd really like to get the whole thing in
one formula for a grand total in T38 only but I'll take whatever works.

Thanks for the help.
--
Diogie
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 06:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"