Hi,
I'm trying to sum data from one worksheet in another work sheet based on two different criteria. I had no problem getting data from sheet 1 when I just had to do an array formula with one criterion, but I can't seem to get the right syntax now that I have two criteria. Any thoughts? This was my attempt:
=SUM(IF('Sheet 1'!$E$24:$E$64='Sheet 2'!$B32 AND 'Sheet 1'!$J$24:$J$64='Sheet 2'!$A33,'Sheet 1'!$F$24:$F$64))
So, if data in col E, sheet 1 meets the criteria in B32,sheet 2 and the data in col J, sheet 1 meets the criterion in A33, sheet 2, I want all of the values from col F, sheet 1 summed in sheet 2. Hopefully I'm making decent sense...any help appreciated!
Thanks,
Tara
Bookmarks