var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I cannot figure this out for the life of me. I have three columns that need to be looked at. I attached the spreadsheet that I am trying to figure out. Notes are in speadsheet. Thanks in advance for all the help.
=SUMPRODUCT(--('FIRE ALARM DEVICES'!$A$8:$A$433=$A19),--(RIGHT('FIRE ALARM DEVICES'!$B$8:$B$433,2)=TEXT(C$18,"00")),--(LEFT('FIRE ALARM DEVICES'!$D$8:$D$433,2)=TEXT($B19,"00")))
copy formula over and down
It's AWL Good!
Thank you for the help and the formula. I do have oen question though:
Becuase I am still new at figuring the formulas and how to manipulate them, Is this formula one formula or is it in sections?
it is one formula
Thanks for all of your help.
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors