Excel help
Thanks Mike,
This works great.
"Mike H" wrote:
Hi,
Try this
=SUMPRODUCT((LEFT(Sheet1!A1:A7,1)="d")*(RIGHT(Shee t1!A1:A7,LEN(Sheet1!A1:A7)-1)))
Change "d" to M or N to sum the others.
Mike
"Yogin" wrote:
Hi
I have a spreadsheet which looks similar to below
Shift
D1
D1
D2
D4
N1
N4
M1
On a difference sheet, currently I add this up manually.
Is there a way that I can auto sum to give me a total using countif.
Days = 4
Mids = 1
Nights = 2
Thanks
Yogin
|