N
n8v_nerd
Well, I have yet another question...sorry to bug you guys so much...
I have a workbook, with several worksheets in it. I am trying to pul
info from the other worksheets onto a summary sheet(named Reports) on
monthly basis(they are named January-December). Using the Indirec
function, I was able to get it so I could type the month into A2 t
pull info from that specific worksheet, that works nice. But, now
there is one more problem I have run into.
Setup for the Months worksheets:
WO#(A) | Location(B) | Name(C) | Date Submitted(D) | Date Completed(E
| Assigned To(F) | Completed By(G) | Estimated Time of work(T)
Now, what I want to do is this. I will have a couple seperate formula
in the end.
Sum up everything in the "Estimated Time" column IF there is a date i
the "Date Completed" column(means its done) from the Report
worksheet...
My Feeble attempt:
=SUMIF(INDIRECT(A2 & "!T:T"),INDIRECT(A2 & "E:E")=TRUE)
Now, as if that wasn't complicated enough, I also want to sum u
everything in the Estimated Time column IF there is a date in the "Dat
Completed" column, AND "HS" or "MS" or "Elem" are in the "Locatio
Column" That way they can be sorted...Didn't even attemtp this one
since I couldn't get the other working...
You guys got any ideas? Thanks in advanc
I have a workbook, with several worksheets in it. I am trying to pul
info from the other worksheets onto a summary sheet(named Reports) on
monthly basis(they are named January-December). Using the Indirec
function, I was able to get it so I could type the month into A2 t
pull info from that specific worksheet, that works nice. But, now
there is one more problem I have run into.
Setup for the Months worksheets:
WO#(A) | Location(B) | Name(C) | Date Submitted(D) | Date Completed(E
| Assigned To(F) | Completed By(G) | Estimated Time of work(T)
Now, what I want to do is this. I will have a couple seperate formula
in the end.
Sum up everything in the "Estimated Time" column IF there is a date i
the "Date Completed" column(means its done) from the Report
worksheet...
My Feeble attempt:
=SUMIF(INDIRECT(A2 & "!T:T"),INDIRECT(A2 & "E:E")=TRUE)
Now, as if that wasn't complicated enough, I also want to sum u
everything in the Estimated Time column IF there is a date in the "Dat
Completed" column, AND "HS" or "MS" or "Elem" are in the "Locatio
Column" That way they can be sorted...Didn't even attemtp this one
since I couldn't get the other working...
You guys got any ideas? Thanks in advanc