Formula help

[ExcelRoy]

Hi,

I am having some trouble with the following formula

=IF(B12="","",SUMIFS($T$12:$T$21,$S$12:$S$21,B12)

This works great if there are single entries within $S$12:$S$21, but if there are 2 entries then it returns the desired SUMIF twice (on each entry)

Can the formula be changed to return the first entry found within $S$12:$S$21

	WORKED	BASIC	OVERTIME
Monday	7.5	7.5	0
Tuesday	7.5	7.5	0
Wednesday	8.5	7.5	1
Thursday	7.5	7.5	0
Friday	7	7	0
Saturday	4	0	4
Tuesday	7.5	7.5	0

Thanks

 

[Fluff]

Can you re-post the data using a mini-sheet as that shows us the columns. Also what are your current & expected results?

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[ExcelRoy]

Hi Fluff,

Think i may have a work around now but thanks for the reply

All the best

 

[Fluff]

Ok

 

[ExcelRoy]

Hi Fluff,

Unfortunately work around didnt work as i had hoped

Maybe this would would be a better way to explain

=IF(G12="","",TEXT(G12,"dddddddd")) reads dates in G12:G21 and returns "Monday", "Tuesday", "Wednesday" from the date

My issue will be if the same date is entered into G12:G21 (ie twice or three times) the formula would return for example "Monday", "Monday", Monday"

So i need the formula to return the first instance found within G12:G21 only

Thanks

 

[Joe4]

What exactly is in cells G12:G21?
Is it text, or dates?
If you change the cell format of the range G12:G21 to "General", what values does it show?

 

[Fluff]

if the same date is entered into G12:G21 (ie twice or three times) the formula would return for example "Monday", "Monday", Monday"

What formula, the one you originally posted would not return that.