Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |