Hi

If the formula is working for you with Paintings, and, assuming the ID
is unique for any range, then just have 3 Sumif's
in the cell
=SUMIF(Pntng_ID,B20,Pntng_Cost)+SUMIF(Jewlry_ID,B2 0,Jewlry_Cost)+SUMIF(Txtl_ID,B20,Txtl_Cost)

I would prefer to have all the data on a single sheet, with an extra
column to determine either Painting, Jewellery or Textile.
Then use an Autofilter to select the category I wanted to look at.
Equally, if there were a column for Sale date, a simple filter by that
column for the day, would give the report required across all
categories.

Finally, with data in that format, a Pivot Table would provide all sorts
of useful analysis.


--
Regards

Roger Govier


"Rao Ratan Singh" wrote in
message ...
Dear Sir,
Thank you for your quick response. I have already post my problem to
this
platform. But I m unable to clear my problem so nobody is properly
giving me
answer. I hope u will definetly solve my problem.

I have three worksheets containing inventory record of paintings,
Jewellery
and Textiles.

All have same column = IDNo. Name of Item Price

I submit daily sales report to my boss which have column in this
manner-

A B C D E
ID No. Name of Item Cost Price Sale Price Gain/Loss

I m using this function to track value from Painting
=SUMIF(Pntng_ID,B20,Pntng_Cost) in
column C.

But How to determine value from three of sheets with two criteria.
Is there any formula to track value from all three sheets putting
"paintings", "Jewellery" and
"Textiles" in column B and in column C the formula can track value
according
to Colum B's
criteria.

I hope this plateform will definetly solve my problem soon.