S
Seller
Hi there I need some help with the following problem...
I have a column
ColA ColB
2 test
3
Total
2 test
3
My total is in the same col as I'm trying to sum and I got the sum to
work like this
=SUM(INDIRECT("F1:F"&ROW()-1))+SUM(INDIRECT("F10000:F"&ROW()+1))
this will give me a sum before current row and after but of everything
now i need to make it conditional so that it only sums where col b =
to test... I had this working but without the big sum like this
SUMPRODUCT((I13:I35)*(H13:H35 = "test"))
can someone please help me combine these so I can sum one column with
totals being it the middle and also only sum based on a different
column relative content?please and thank you
I have a column
ColA ColB
2 test
3
Total
2 test
3
My total is in the same col as I'm trying to sum and I got the sum to
work like this
=SUM(INDIRECT("F1:F"&ROW()-1))+SUM(INDIRECT("F10000:F"&ROW()+1))
this will give me a sum before current row and after but of everything
now i need to make it conditional so that it only sums where col b =
to test... I had this working but without the big sum like this
SUMPRODUCT((I13:I35)*(H13:H35 = "test"))
can someone please help me combine these so I can sum one column with
totals being it the middle and also only sum based on a different
column relative content?please and thank you