Total values based on text and date occurances.

[s13igh]

Hi,

At the moment I have this formula to total number of times a word appears in a given date range.

[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]=COUNTIFS('Projects Tracker'!B20:B25000,">="&F8,'Projects Tracker'!B20:B25000,"<="&H8,'Projects Tracker'!F20:F25000, "*Sector: Corporate*")

F8 = Start Date
H8 = End date

B20:B25000 = List of dates
F20:F25000 = List of words (i.e "Sector: Corporate")

[/FONT]I now want to subtotal £'s in U20:U25000 when the adjacent values in columns B&F match the Start & End dates as well as a defined text

(i.e "Sector: Corporate")​

is this possible?

Thanks for the advice.

 

[william_man]

I think this should give you what you need:

=SUMIFS('Projects Tracker'!U20:U25000,'Projects Tracker'!B20:B25000,">="&F8,'Projects Tracker'!B20:B25000,"<="&H8,'Projects Tracker'!F20:F25000, "*Sector: Corporate*")

 

[s13igh]

I think this should give you what you need:

=SUMIFS('Projects Tracker'!U20:U25000,'Projects Tracker'!B20:B25000,">="&F8,'Projects Tracker'!B20:B25000,"<="&H8,'Projects Tracker'!F20:F25000, "*Sector: Corporate*")

Thats Absolutly brilliant, copied and paste, worked right away! thank you.