SUMIF Function

[emilija]

I have tow tables, one is a date base and second is a table where I do some
calculation using SUMIF Function, so second table should at the end sum
every line from table one. Problem is that firs table can be different every
mount (more or less row). Is it some how possible when sumif function choose
the number from first table, that number become somehow mark, (colored the
cell, the digit....) so eventually to be easier for my whish line I have
mist. Any hints!
Thanks in advance, Emilija

 

[Roger Govier]

Hi Emilija

Sumif will take a whole column range as its argument.
Try changing your formula to something like
=SUMIF(Sheet1!B:B,"A",Sheet1!C:C)
This will then pick up all rows in your table where column B= the letter A