Help with multi cell IF THEN functions

[ianslade]

Example formular problem.xlsx

I am looking for help with a multi cell IF THEN type function (See attached workbook) I am looking for a cell in a summary table to find all the bookings of a certain category, find the associated value (within date parameters) and then auto sum the values into another cell. I have tried a few formulas and searches on the forum, but can't get it to work.

The attached is an example and in the actual work book I will be summarizing on a different work sheet and will need to pull the data across.

Any help you can provide on the correct formula would be greatly appreciated. Thank you

[Special-K]

in G2
=SUMPRODUCT(($B$2:$B$24=RIGHT($F2,1))*($D$2:$D$24=RIGHT(G$1,1)+0)*($C$2:$C$24))

copy right and down to as far as I4

[Pete_UK]

Put this formula in G2:

=SUMIFS($C:$C,$B:$B,SUBSTITUTE($F2,"Total ",""),$D:$D,--SUBSTITUTE(G$1,"Week",""))

then copy across to I2, then copy G2:I2 down to row 4.

Hope this helps.

Pete

[BB79]

Hi
Not sure if this is allowed but I thought I'd jump in on the end of this thread to save starting a new one on the same subject.
I am having difficulty with something that is most probably fairly simple. I've done tutorials, watched YouTube videos and even embarked on a Mook course but to no avail.
Basically I am setting up a spreadheet budget for certain workshops that my organisation does. There are 5 types and each costs a different amount.
All I want to create is a formula that states = if a '1' is put into cell A3 then a '250' will appear in D3, if a '2' is in cell A3 then a '350' will be in D3 and so on.

The formula I have created so far is - =IF(a3=='1',d3="250'). Now I don't have a false value but a load of true values so is there where I'm going wrong?

Thanks so much

Simon

[Pete_UK]

Simon,

please read the Forum Rules at the top of the screen, especially Rule 02 - you should not attempt to hijack someone else's thread, but start your own instead. Include a link back to this one if you think it is relevant.

Pete

[BB79]

Sorry Pete - thought it would be better to keep it to one thread - will start a new one.

Thanks

Simon

[ianslade]

Thank you Pete_UK that works a treat