Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: JWhitener1986
- Order by date
-
Using SUMIF with REPLACE(LEFT as criteria for an entire section
Thank you so much! Those array formulas did just the trick! Granted, it is a horrible reporting fromat, but you have made it actually usuable. Thank you again!- JWhitener1986
- Post #8
- Forum: Microsoft: Office
-
Using SUMIF with REPLACE(LEFT as criteria for an entire section
vgulielmus, I tried those array formulas but they don't account for blank spaces. I'm trying to create a formula that I can just cover the whole report with, because which cells are filled will change weekly and I don't want to rebuild the formula every week. Essentially, I'm trying to nest...- JWhitener1986
- Post #5
- Forum: Microsoft: Office
-
Using SUMIF with REPLACE(LEFT as criteria for an entire section
Hi Skip, Here is the data cut and pasted from the report: Monday 6.23 Tuesday 6.24 Wednesday 6.25 Thursday 6.26 Friday 6.27 Saturday 6.28 Sunday 6.29 Springfield Springfield Springfield Springfield Springfield Springfield Springfield 7296/80000 7520 7520 7520 4500 7520 7520 7520 7520...- JWhitener1986
- Post #3
- Forum: Microsoft: Office
-
Using SUMIF with REPLACE(LEFT as criteria for an entire section
This one has been puzzling me for a few days. This sheet I am using is attached. What I am trying to do is create a function that sums up all the containers on the sheet and a function that sums up all the lids. This is a twofold problem: 1. Containers – These are always standalone numbers...- JWhitener1986
- Thread
- Replies: 7
- Forum: Microsoft: Office
