pulling 2 values for sum product

Could you provide more info - ie where in Workbook B is the data located ?

The calculations you want to perform are what exactly ? ie
Type = "CO" and Size = "any" or Size = 1 (or 2, or 3, or 4) ?
Type = "CO" and Size = 3 or 4 And Room No. >= 4000 and <= 4999

etc...

If you could provide a couple of sample files that would be helpful.

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.


jenmarie, in the past "x" hours I think you've:

i) posted a thread into the wrong forum

ii) posted your question into another thread

ii) posted this in duplicate (this time in less detail than the first time)

Please endeavour to read and subsequently adhere to all of the Forum Rules....


We (Mods) prefer to spend our free time answering questions as opposed to berating other members or conducting "housekeeping" on the Board - in other words the more time we spend on Admin the less we can assist... so we ask you help us in that respect by operating within the pretty basic guidelines.