O
ODB
Hi folks,
1st post so please be gentle!
I am after a formula that works in the same way as a Sumif.
I am trying to count particular data for a certian week. However thi
data is in more than 1 column!
Currently we just add multiple SUMIF's together, but I'm sure ther
must be a way to add a certain amount of columns together.
EXAMPLE
-Current way of doing it:-
=SUMIF(Master_Data!$C:$C,D38,Master_Data!$CY:$CY)+SUMIF(Master_Data!$C:$C,D38,Master_Data!$CZ:$CZ)+SUMIF(Master_Data!$C:$C,D38,Master_Data!$DA:$DA)
Is there another formula that will add up all these neighboring column
for a particular week?
I know you can't do it with columns that are seperated but when th
columns are in order eg A,B,C,D,E I figure there must be something tha
will do it!
Please help as we have been working this way for 2 years and I'
convinced there is an easier and tidier way of doing this
Cheers
Chri
1st post so please be gentle!
I am after a formula that works in the same way as a Sumif.
I am trying to count particular data for a certian week. However thi
data is in more than 1 column!
Currently we just add multiple SUMIF's together, but I'm sure ther
must be a way to add a certain amount of columns together.
EXAMPLE
-Current way of doing it:-
=SUMIF(Master_Data!$C:$C,D38,Master_Data!$CY:$CY)+SUMIF(Master_Data!$C:$C,D38,Master_Data!$CZ:$CZ)+SUMIF(Master_Data!$C:$C,D38,Master_Data!$DA:$DA)
Is there another formula that will add up all these neighboring column
for a particular week?
I know you can't do it with columns that are seperated but when th
columns are in order eg A,B,C,D,E I figure there must be something tha
will do it!
Please help as we have been working this way for 2 years and I'
convinced there is an easier and tidier way of doing this
Cheers
Chri