Formula needed for add a range of cells based on date range and text in other cells

**excelteam777** · 02-14-2020, 03:54 PM

WS Attached

(Dashboard) K6 = Formula
On “Dashboard”, when a start date(G1) /end date(G2) is entered,
Formula will return based on that date range from “MAIN” B3:B17,
And add/total the number(s) in”MAIN” AM3:AM17 only if in N3:N17 there is a number 1 or higher

**Sam Capricci** · 02-14-2020, 04:41 PM

if I'm understanding what you want, wouldn't that just be simply adding one more condition to your sumifs like this? ...
=SUMIFS(MAIN!$AM$3:$AM$17,MAIN!$B$3:$B$17,">="&G1,MAIN!$B$3:$B$17,"<="&G2,MAIN!$N$3:$N$17,">"&0)

**excelteam777** · 02-15-2020, 08:36 PM

YES, works great, thanks!

Formula needed for add a range of cells based on date range and text in other cells

LinkBack

Thread Tools

Rate This Thread

Display

Formula needed for add a range of cells based on date range and text in other cells

Re: Formula needed for add a range of cells based on date range and text in other cells

Re: Formula needed for add a range of cells based on date range and text in other cells

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] formula needed for multiple cells based on date range

Formula needed to sum multiple cells based on date range

[SOLVED] Formula needed to auto populate in a range of cells on mult sprdsheets based on text input

[SOLVED] Add up cells based on text within a date range

[SOLVED] Formula Needed to count a range of cells based on criteria in 2 other cells

[SOLVED] Macro needed to clear cells in range based on value of cells in another range

Formula needed: autofill a cell with today's date when another range of cells are edited

Bookmarks

Bookmarks

Posting Permissions